There's moreā€¦

There is a similar concept known as cumulative sums, which we discussed in the Using the Rangesum() function to plot cumulative figures in trendline charts recipe. However, there is a glaring difference between the two. While cumulative takes into consideration all the previous months and years to the current, an MAT will always consider the previous 12 months. In a way, it is a rolling 12-month sum at any given point in time.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset