Solved

Cumulate Last Twelves Months

  • 23 April 2023
  • 2 replies
  • 202 views

Userlevel 1
Badge +2

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:

CUMULATE(Revenues,Month)
[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?

Many thanks

icon

Best answer by Benoit 26 April 2023, 15:55

View original

2 replies

Userlevel 6
Badge +12

Hi Ahmed,

You can try the movingsum() function

 

That should look like something like this:

 

Hope it helps.

 

Best,

Benoit

 

 

 

 

Userlevel 1
Badge +2

Hi Benoit,

 

Many thanks for the answer, very helpful!!

 

Have a good day,

Reply