topic Cumulative summary in pivot table in QlikView

Cumulative summary in pivot table

annabergendal — Fri, 11 Sep 2015 13:04:56 GMT

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

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

Thanks!

Gysbert_Wassenaar — Fri, 11 Sep 2015 13:21:49 GMT

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

annabergendal — Fri, 11 Sep 2015 13:30:19 GMT

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.