Hi,
I have the following graphs:
1,2 and 3 are correct.
The first one shows my variable SPEND by months and the second shows it's division by the dimension SEG.
The formula in both is the same: Sum(SPEND).
Now I want to show the movile sum of the variable SPEND in a six months term.
The third graph shows it without any other partition and it works perfectly. The formula is
rangeSUM(above(sum(SPEND),0,6))
But when I want to open it by the dimension SEG (4TH GRAPH ) it doesn't work properly. I've tried with the following formula:
AGGR(rangeSUM(above(sum(SPEND),0,6)),SEG,Month)
but it also doesn't work.
The 4th graph should look like this:
Thank you in advance!!