Cumulative sum in chart

RighettiAndrea — Sat, 16 Nov 2024 18:29:43 GMT

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

Re: Cumulative sum in chart

sunny_talwar — Fri, 12 Jun 2020 13:17:33 GMT

Try this

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

Re: Cumulative sum in chart

RighettiAndrea — Fri, 12 Jun 2020 13:34:54 GMT

YOU ARE AMAZING, MAN!

It works great! Thanks a lot!!

topic Re: Cumulative sum in chart in App Development

Cumulative sum in chart

Re: Cumulative sum in chart

Re: Cumulative sum in chart