What have we done ? What we want and what we have done is the last 12 months sum calcution excluding current month. That means that e.g. in Apr 2015 we will see sum of all values from Apr 2014 to Mar 2015; in May 2015 sum of all values from May 2014 to Apr 2015, …

LTM calculation is made and we can stop here :) But what I want to show further is some simple useful modification.

Wrong “filtering” !

Lets say that we want to show values just for years 2014 and 2015. In oder to do this, the first idea would be to put Order Date in filter and choose those two years.

If we do that, we will get different (wrong) second graph!

Especially give the attention to the values in 2014 of LTM calculation ! What happened ?

Since we defined the calculation as a sum of previous 12 months, and filtering put out older data, the calculation can be done just with available data. It means that e.g. in Apr 2014 we will have only the sum of 3 months values: from Jan 2014 to Mar 2014.

To make correctly our first attention, put out the given filter in order to have again all data, right click on 2012 and 2013 column headers and choose Hide:

Finally, we have the view what we initially wanted to have :)

www.linkedin.com/pulse/tableau-ltm-moving-calculation-finance-kpi-leon-agatic

Found this post useful? Kindly tap the ❤ button below! :)