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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative sum in pivot

Hi, i have a pivot table with category in rows and months in columns. I need a cummulative sum by months. Without accumulation, i simply have =sum({$<[Category]={'Books'} >}Sales) etc. How to change it to accumulation by months?


JanuaryFebruaryMarch etc
Books562
Jewelery345




need to get


JanuaryFebruaryMarch etc
Books51113
Jewelery3712
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Depends on what you need. Perhaps using the function above() or before() is enough for your situation. See Calculating rolling n-period totals, averages or other aggregations for more information.


talk is cheap, supply exceeds demand
Not applicable
Author

I need a simply measure just like in example in my post.

If you need more details, the category here I have as expressions: =sum({$<[Category]={'Books'}>}Sales) and =sum({$<[Category]={'Jewelery'}>}Sales), Month name is a dimension

Sth like example attached below, but instead of date, i have month name