Cumulative in Pivot Table.

[neha_shirsath]

Hello Community,

Need your help for below problem.

I have attached qvw in that I want cumulative for particular Item Name.

At present i am getting data as follows

Item Name	DATE	sum(Qty)	Cumulative
A	21/2/2013	15	15
	1/2/2012	75	90
B	1/2/2012	42	132
	4/2/2013	45	177
	6/4/2013	41	218
C	1/2/2012	70	288
	1/12/2013	20	308
D	1/2/2012	21	329
	9/5/2013	31	360
E	1/2/2012	34	394
	10/12/2013	34	428

i want data as-

Item Name	DATE	sum(Qty)	Cumulative
A	21/2/2013	15	15
	1/2/2012	75	90
B	1/2/2012	42	42
	4/2/2013	45	87
	6/4/2013	41	128
C	1/2/2012	70	70
	1/12/2013	20	90
D	1/2/2012	21	21
	9/5/2013	31	52
E	1/2/2012	34	34
	10/12/2013	34	68

Please help me with the problem.

Thanks.

-Neha

[Sokkorn · Accepted solution]

Hi Neha,

Your accomulative expression should be like this

RangeSum(Above(Total Sum(Qty),0,RowNo()))

Regards,

Sokkorn

[neha_shirsath]

Hi Sokkorn,

Thank you so much it's work.

-Neha