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

# Running sum of MoM difference

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?

• ###### 1. Re: Running sum of MoM difference

Hello Jonas,

First, the [lookup date filter] is brilliant !

Please have a try at editing the table calculation of the running diff.

Regards

Lei

• ###### 2. Re: Running sum of MoM difference

Thanks Lei, unfortunately that wont quite do it.

I would like the mark for 2017/teal line to be the difference between sales in dec 2016 and sales in jan 2017 (43 971 - 96 999 = -53 028). and then do a running sum of the monthly diff forward.

I'm not completly sure about what numbers the calc in your picture provides, but it doesn't add up

• ###### 3. Re: Running sum of MoM difference

Hello Jonas,

It took me time to try using one single table calculation to achieve the running difference.

Thus, I use data blend instead, to fetch the Dec sales of the previous year, from the secondary data source.

I attached the sample workbook.

This is a very simple sample, because I only defined year in the relationship definition.

In your real case, there might be more dimensions to add to.

Regards

Lei

1 of 1 people found this helpful
• ###### 4. Re: Running sum of MoM difference

Thanks Lei,

I went with a similar approach where I used a lookup with datepart to find last years December and calculated the diff from that. Will have a look at your solution aswell