Rolling 12 month analysis for Fiscal calender

Wed, 24 Aug 2011 06:15:09 GMT

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.

Re: Rolling 12 month analysis for Fiscal calender

Wed, 24 Aug 2011 06:18:25 GMT

One more thing i want to add for the above post is that fiscal calendar starts from Jul 1 and ends Jun 30.

Thanks