Cummulative sum in grouped chart

[MvR]

Hello all,

I am trying to get a chart like example below from a query which give me a tabel like attached excel. Goal is to get a cummulative total over the periods. So period 1 = Period 1, Period 2 = Period 1+2, etc.

Does anyone know how to achieve this?

Thanks in advance for your help.

[OmarBenSalem]

Create a bar chart:

as dimension:

dim1: Period

dim2: Year

As measure:

sum(Amount)

[MvR]

Thank you for your suggestion, however this doesn't give me a cummulative sum

[OmarBenSalem · Accepted solution]

I couldn't see the cumulative sum in ur graphic.
try this if u want cumulative sum
aggr(rangesum(above(sum(Amount),0,rowno())),Year,Period)