4 Replies Latest reply on Nov 5, 2018 10:50 PM by Jonas Karlsson

    Running sum of MoM difference

    Jonas Karlsson

      Hi guys,

       

      I have a chart that gives me the MoM difference for current year and previous year (2nd graph in the example workbook). I use a lookup filter to keep the value for previous years January...

       

      I would like to get a running total of these MoM-differences, like in the third graph BUT i need it to start at January like the MoM difference in graph no.2.

       

      This doesn't make much sense for sales, but i would like to track the running difference for our customer base current year relative to the number i have in december for previous year.

       

      Example workbook is saved in 10.5 using superstore data...

       

      Any ideas?