QlikView App Dev

[annabergendal]

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!

[Gysbert_Wassenaar]

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]

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.