1 Reply Latest reply: Jun 14, 2016 11:50 AM by Sunny Talwar RSS

    12 Rolling Months on X-as

    Marc Catteeuw

      I have to create a graph with Sales of last 12  months  (June 2106 jback to July 2105) ,   compared with the year before (June 2015 - July 2014).

      Data on the graph will have two lines ::

      -> one line is the sales of 12 month from now until 12 months back

      -> second line is the sales of 13 month ago until 24 months ago.

       

      X-as contains 12 months not 24. (today we are for ex. june 2016):

      Jun 2016

      May 2016

      Apr 2016

      Mrt 2016

      Feb 2016

      Jan 2016

      Dec 2015

      Nov 2015

      Oct 2015

      Spt 2015

      Aug 2015

      July 2015

       

      Can someone help me.

       

      thx