Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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