1 Reply Latest reply: Aug 24, 2011 2:18 AM by Abhishek Pandey RSS

    Rolling 12 month analysis for Fiscal calender

    Abhishek Pandey

       

      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.