How to show rolling 12 months and perivou rolling 12 month analysis for Fiscal Calender.
The table below describes how calendar periods relate to fiscal years and periods.
Calendar Period ,Fiscal Year ,Fiscal Period
7/1/2006, 2007 ,1
8/1/2006 ,2007 ,2
9/1/2006 ,2007, 3
10/1/2006, 2007, 4
11/1/2006, 2007, 5
12/1/2006 ,2007 ,6
1/1/2007 ,2007 ,7
2/1/2007 ,2007, 8
3/1/2007 ,2007, 9
4/1/2007 ,2007 ,10
5/1/2007, 2007 ,11
6/1/2007 ,2007, 12
7/1/2007 ,2008, 1
8/1/2007 ,2008, 2
9/1/2007 ,2008, 3
I have attched some snapshot for the output i want .
Plesae note that snapshot ayyached is for the normal calender i want sam analysis but based on the fiscal calender.
Kindly help me regarding this.
