Cumulative Sum in QlikSense Table object

[riyazasma1009]

Hi,

I have created a table in QlikSense as shown below:

Product	Sub Product	Day	Date	Sales
A	AA	Tuesday	17/9/2019	100
A	AB	Wednesday	30/9/2019	200
B	AA	Tuesday	17/9/2019	150
B	AB	Wedensday	30/9/2019	150

I wish to add a column in the table which would calculate the cumulative sum of sales for each product, sub product combination. The resulting table should be as shown below:

Product	Sub Product	Day	Date	Sales	**bleep** Sales
A	AA	Tuesday	17/9/2019	100	100
A	AB	Wednesday	30/9/2019	200	300
B	AA	Tuesday	17/9/2019	150	150
B	AB	Wedensday	30/9/2019	150	300

Can someone please help me with what expression needs to be written in **bleep** Sales column?

Thanks.

[Amit_Prajapati]

You can use the Rangesum funtion in this case to achieve the same.

RangeSum(Above(TOTAL Sum(Sales), 0, RowNo(TOTAL)))

Let me know if it's working for you or not.

[BrandonFontes]

@riyazasma1009 

Try this:

=Aggr(RangeSum(Above(Sum(Sales), 0, RowNo(TOTAL))),Product, [Sub Product])