0 Replies Latest reply on Oct 12, 2017 5:13 PM by Cecilia Saldaña

    Two years running total (calculating difference)

    Cecilia Saldaña

      Hello,

       

      I have a table with the following columns.

       

      DateAmount
      jan 201720
      feb 201730
      jan 201640
      feb 201625

       

      I want to get a chart displaying year by year data as shown in attachced image,,, including the difference between years (mont by mont).

      I get to the point where I can display month by month difference... but when I try to see (in the chart) the difference cumulative amount... i just cant...

       

      Captura de pantalla 2017-10-12 a la(s) 18.51.50.png

      The upper part is a cumulative chart comparing two years (light and dark blue each)

      The chart below is currently showing each month´s difference, but I want to see the cumulative difference...

       

      Any ideas?

       

      Thank you