Forum Discussion

frankhofmans's avatar
frankhofmans
Helper IV
4 years ago

Rolling LTM

hi PBI experts,

 

i want to show a rolling LTM for the last 12 periods (so every period has to show the LTM sales). i have the following monthly facts table:

 

PeriodSales
2019-0113
2019-0215
2019-0315
2019-0418
2019-0510
2019-068
2019-0711
2019-0819
2019-0913
2019-1012
2019-1114
2019-1213
2020-0112
2020-0215
2020-0314
2020-0418
2020-0510
2020-0612
2020-0720
2020-0821
2020-0917
2020-1019
2020-1115
2020-1218
2021-0116
2021-0213
2021-0319
2021-0417
2021-0518
2021-0615

 

I want the following output:

 

Period filter: select the period, fe 2021-04

 

output:

 

PeriodValue 
2020-05159Sales between 2019-06 and 2020-05
2020-06163Sales between 2019-07 and 2020-06
2020-07172Sales between 2019-08 and 2020-07
2020-08174etc
2020-09178etc
2020-10185etc
2020-11186etc
2020-12191etc
2021-01195etc
2021-02193etc
2021-03198etc
2021-04197etc

 

So i want to present the last twelve month from the selected period, and in those twelve month the LTM sales.

 

I hope someone can help me out.

 

Thank in advance,

 

Regards,

 

Frank

Need Help

3 Replies

    • frankhofmans's avatar
      frankhofmans
      Helper IV
      4 years ago

      hi Greg,

       

      thanks for the link. I still haven't got the right result. i only get the results per period, en not the total of the 12 months. Do you have another suggestion?

       

      Regards,

       

      Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi frankhofmans ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.