3 Replies Latest reply: May 26, 2017 1:22 PM by Paulo Abreu RSS

    Comparing successive sales (i.e).

    Paulo Abreu

      Hi all,

       

      As an example I have a sales table and a typical master calendar table with SalesDate, Month, MonthYear, etc.

       

      Sales:

      SalesDate

      Sale

      2016-12-20

      300

      2017-01-01

      300

      2017-02-20

      450

      2017-03-22

      490

      2017-03-23

      90

       

      I need to make a table/graph with each successive variation from month to previous month, each month shows the increase % in sales from previous month, like this:

       

      MonthYear

      Variation previous month

      Jan-2017

      0%

      Feb-2017

      +50%

      Mar-2017

      +28%

       

      My doubt is how to get the sales from the previous row on dimension MonthYear, for all the dimension values.

      Thanks Regards