# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for
Did you mean:
Contributor

## Cummulative sum in grouped chart

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?

Labels (3)

• ### sum

1 Solution

Accepted Solutions
Partner
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)
3 Replies
Partner

Create a bar chart:

as dimension:

dim1: Period

dim2: Year

As measure:

sum(Amount)

Contributor
Author
Thank you for your suggestion, however this doesn't give me a cummulative sum
Partner
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)