CUMULATIVE SUM with partition

[Franco2]

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!!

[marcus_sommer]

You could try it with: rangeSUM(above(total sum(SPEND),0,6))

- Marcus