Hi experts,
I'm trying to build a Rolling 12 month report. I found online the way to do it, and it works fine except for one situation, and I'm hoping someone here can help.
The following is what I have at the moment:
Column 1: Relative to Current Point of View for Year offset by -1
Range from Prompt for Period to 12 with iterations 0
Column 2: Current Point of View for Year
Range from 01 to Prompt for Period with iterations 0
As long as my first period isn't 01 and my last period isn't 12, it works perfectly. But of course if I use 01 and 12, the reports comes out with 24 months instead of 12. The idea would be that column 1 shouldn't appear at all when the propmt is 01, but I'm not sure it's even possible to do that in FR.
Any help?