1 Reply Latest reply: Oct 24, 2012 9:01 AM by jagan mohan rao appala RSS

    How to group date according to Financial Year?

      Hi,

      I am finding a way to check whether a given date is fall within the financial year period. After that, I want to count on the ID of the Date where the Date is falling inside the financial year range. The FY will be my dimension in the report.

       

      Financial Year 2012: July2011 to Jun2012

      Financial Year 2013: July2012 to Jun2013

       

      Raw Data:

      ID

      Date

      001

      14/02/2012

      002

      20/08/2012

      003

      31/03/2012

      004

      14/06/2012

      005

      22/07/2012

      006

      31/05/2012

       

      After sorting:

      Dimension FY

      Date

      FY2012

      14/02/2012

       

      31/03/2012

      31/05/2012

      14/06/2012

      FY2013

      22/07/2012

       

      20/08/2012

       

      Result:

      Dimension FY

      Count of ID

      FY2012

      4

      FY2013

      2

       

      Thanks for your help and guides!

       

      Regards,

      SC