5 Replies Latest reply on Jul 20, 2018 7:16 AM by Shinichiro Murakami

    Rolling 12 Months with Parameter

    Ashok Ramineni

      Hello,

       

      I would like to display rolling previous 12 months and previous to previous 12 months Quantity and % difference between them in the same chart. User will have provision to choose the parameter from 12 to 6 or 24 months.

      Lets say: Max of Month is Sep 2015 (9/30/2015)

      And would like to display the Quantity as a trend line & % difference between those values for ...

      Current Year: Sep 2015 to Aug 2014

      Prior Year: Sep 2014 to Aug 2013

       

      Also would like to display the Total Quantity for Current Year & Prior Year & difference % of it in separate sheet.

       

      Please advice.

       

      Example:

       

      Thanks!