Cumulative pivot table

Tue, 25 Feb 2014 15:04:13 GMT

Hello,

i have a pivot table with two dimensions, "month" and "year", and one expression ("sales"). i need to create another pivot table, similar to the original one, but on a cumulative basis: for example, month 2/12 will be the sum of sales of both 1/12 and 2/12. month 3/12 will be the sum of sales of 1/12, 2/12 and 3/12.... please see below:

the pivot table a have:

'	'	2014	2013	2012
Jan		$170	$134	$119
Feb		-	$143	$126
Mar		-	$135	$124
Apr		-	$146	$128
May		-	$152	$131
Jun		-	$143	$133
Jul		-	$144	$136
Aug		-	$143	$138
Sep		-	$141	$141
Oct		-	$140	$143
Nov		-	$138	$146
Dec		-	$137	$148
Total		$170	$1,695	$1,611

the cumulative pivot table i need to create:

'	'	2014	2013	2012
Jan		$170	$134	$119
Feb		-	$277	$245
Mar		-	$412	$369
Apr		-	$558	$497
May		-	$710	$628
Jun		-	$853	$761
Jul		-	$997	$896
Aug		-	$1,140	$1,034
Sep		-	$1,281	$1,175
Oct		-	$1,420	$1,318
Nov		-	$1,558	$1,463
Dec		-	$1,695	$1,611
Total		$170	$1,695	$1,611

thanks

Re: Cumulative pivot table

hic — Tue, 25 Feb 2014 15:35:01 GMT

You can achieve this using RangeSum(Above(Sum(Amount), ... ) as expression. See more in the blog post about Pareto analysis, where such an accumulation is used.

HIC

topic Re: Cumulative pivot table in QlikView

Cumulative pivot table

Re: Cumulative pivot table