Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
BabyyGurusamy
Contributor
Contributor

Cumulative Sum in Qlikview Pivot Table

I have a pivot table with 3 dimensions (Year, Quarter, Month) and calculating cumulative sum of sales using below expression

RangeSum( Above(TOTAL Sum(Sales), 1, Rowno(TOTAL)))

Cumulative sum is working fine when dimensions are fully expanded and not giving correct result when its collapsed. 

Do we have any workaround for this issue?

2 Replies
Anil_Babu_Samineni

@BabyyGurusamy  can you show where it is showing with expand and collapse?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
BabyyGurusamy
Contributor
Contributor
Author

Please refer the attached screenshot.Pivot Table.PNG