Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alejovacca
Contributor
Contributor

Cumulative sum in Pivot Table

Hi guys,

I am trying to do a cumulative sum of the values in the column ToShip for each Product Group. The red numbers are the expected values.

CumulativeSum.png

I was trying to use the formula RangeSum(Above([To Ship], 0, RowNo()))but a I get the same value that [To Ship] column.

Do you have any idea?

Thanks in advance

Labels (1)
2 Replies
dplr-rn
Partner - Master III
Partner - Master III

thats the right idea.

try this
RangeSum(Above(Sum([To Ship]), 0, RowNo()))

if not try diagnose by checking what above([To Ship]) returns
alejovacca
Contributor
Contributor
Author

Yes, I used the sum inside above but it doesn't work.