Hi Pigment community,
I want to realise a LTM (Last Twelves Months) analysis for a metric.
For the moment, I’m able to cumulate only by the beginning of the period with the function:
[Filter: Month.Year = Year."FY 22" OR Month.Year = Year."FY 23" OR Month.Year = Year."FY 21"]
I can make it “restart” each year with using CUMULATE(Revenues,Month,Month.Year) but I want to cumulate the last 12 Months only
LTM Revenue Feb 22 should be starting from Feb 21 and not Jan 21.
How can I do that?
Best answer by BenoitView original