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: 
annabergendal
Partner - Creator
Partner - Creator

Cumulative summary in pivot table

How can I create a cumulative summary in a pivot table?

In the attached example I would like to have a total-coumn to the right in the table (just next to Customer C) summarizing the sales cumulative.

So...

Total

10

15

20

35

45

Can I create this in the table or do I need to add it to the script?

Thanks!

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this expression: rangesum(above(total sum(Sales),0,RowNo(total))). This expression does have some drawbacks regarding selections in your date column. See this document for more information: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
annabergendal
Partner - Creator
Partner - Creator
Author

Thanks,

but how to get it "separated" from the dimensions?

See attached...

I want the same summary for all Customers, all customers should build the same summary.