Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.