Cumulative sum in chart

[RighettiAndrea]

Hi everyone,
I know that this is a post very similar to others I already red, but in my case there is something still wrong...

I have a bar chart where I'd like to see the cumulative sum of a value (Fon - Prog Stamp). The X axis is showing the weeks (Settimana) of the selected time range, while dividing the measure I put into other bars (Isola).

The functions I'm using for this measures are the same as in another post I saw here (and in that case they run).

Here's my measure:

RangeSum(Above(Sum(S_ODL.LORDO_FONDERIA/DT_ARTICOLI.PZZBATT),0,RowNo()))

I've also tried to replace RowNo() with the week dimension but nothing at all, the measure still shows the calculation without adding the previous values. I think I need the Aggr function but I'm not able to use it properly in this case. In fact, I noticed that removing the bar dimension (Isola), the function runs correctly...

Thanks a lot

[sunny_talwar · Accepted solution]

Try this

Sum(Aggr(
    RangeSum(Above(Sum(S_ODL.LORDO_FONDERIA/DT_ARTICOLI.PZZBATT), 0, RowNo()))
, Isola, Settimana))

[RighettiAndrea]

YOU ARE AMAZING, MAN!

It works great! Thanks a lot!!