Cumalative Months

alex-wb — Tue, 15 Jun 2021 16:57:09 GMT

Hi all,

I am looking to do a current RYTD based on 1-12 months view comparison vs the previous 12 month before that 13-24 month. However, ever month will be cumulative and backed by the preceding 12 months of data. So for example, month one is May 2021 and is backed by May 2021- April 2020 data, and April 2021 is back by April 2021- March 2020 data and so on so forth. These dates will all shift on a monthly basis as the we enter a new month. I have attached an excel document show what I am trying to achieve.

The data below is made up data but will show what I am trying to achieve.

Any help is much appreciated.

Thanks,

Alex

Re: Cumalative Months

jwjackso — Tue, 15 Jun 2021 18:27:45 GMT

Henri's As-Of-Table should work.

topic Cumalative Months in App Development

Cumalative Months

Re: Cumalative Months