Forum Discussion
Dynamic rolling previous N months
Hi all, I'm looking for a way to show the rolling N months sum, and have the matrix table respond dynamically. For example if I choose Aug 2024 and 3 months, the matrix should only show JUN, ...
Thank you both for your detailed solutions.
Unfortunately this did not solve the issue, the months were either non-cumulative or the filters didn't work.
Using Rank_YM to rank the [Year Month] column also resulted in circular depandancy.
Eventually I managed to get it working using the mentioned video and some added transformations, though I'm not sure why the second calendar table is required.
Thanks again!
Hi YO_CO ,
We're sorry that our ideas didn't help you solve your problem, and we're glad to hear that you finally found a solution. Could you please explain your solution so that everyone can learn from it, please?
Best Regards,
Dino Tao