I am working on creating a traling twelve months in HFR, so say if I am in Jan - FY13 I would need (Jan->FY13+(Feb through Dec ->FY12)) = Jan FY13 TOTAL. So essentially I need 12 months trending the current month + past 11 months to give me JAN TOTAL. I need this to be dynamic based on current point of view for period. I am thinking the best way to accomplish this would be have years and period in the column.
I would have 24 data columns;
1st 12) current point of view for years -1 then (Jan through Dec)
2nd 12) current point of view for years then (Jan through Dec)
Then I could have 12 more columns that would sum the 12 months based on the current POV. So if Jan - FY13 I would need (Jan->FY13+(Feb through Dec ->FY12)) = Jan FY13 TOTAL. But I am not sure how to write the IF statement using current point of view. Then I am wondering if I can use advanced supression based on the current point of view to show the correct 12 month totals. I will always need to show a 12 month rolling total.
Any help will be greatly appreciated.