5 Replies Latest reply on Apr 1, 2016 9:18 AM by Andrew Watson

    Display of rolling 24 months data

    Sunil Bairam

      Hello SME's

       

      I would like to display bar chart in the following format using a parameter in a single worksheet

       

      Example:

       

      If my Parameter [Auths Thru] date is 03/2016, I need in the following way

       

      1. Rolling 12 months data (from 02/2016 to  03/2015)

                I have achieved with the following calculation

       

      IF DATETRUNC('month',[YYYYMM Date]) >= DATETRUNC('month',DATEADD('month',-12,[Auths Thru]))

      THEN

      [Students]

      ELSE

          NULL

      END

       

      I need help to display Rolling 24 months data (from 02/2015 to 03/2014)

       

      ??

       

      Can you guys please help me with calculating the above

       

      Thanks

      Bairam