2 Antworten
Video's and pages aside @Diksha Joshi, as Caleb has explained, these are really window calcs. For example:
Window_Avg(Sum(Sales),0,-4)
Will perform a running sum (cumulative) for the last 4 periods in your data.
But in order to perform a difference calc against another period, you'll need to change the summation vectors with a new calc:
(Window_Avg(Sum(Sales),0,-4) - Window_Avg(Sum(Sales),-4,-8)) / Window_Avg(Sum(Sales),-4,-8)
Should do it.
Steve