Pivot table cumulative row sum percentage

[zuriqi]

Hi

Is it possible to use pivot table to show the cumulative row sum percentage (not % running total) ? sample is shown below


[TABLE="width: 328"]
<tbody>[TR]
[TD]Count of Date
[/TD]
[TD]Column Labels
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels
[/TD]
[TD]Pass
[/TD]
[TD]Failed
[/TD]
[TD]Grand Total
[/TD]
[/TR]
[TR]
[TD="align: center"]Jan
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]17
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Feb
[/TD]
[TD="align: center"]17
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]28
[/TD]
[/TR]
[TR]
[TD="align: center"]Mar
[/TD]
[TD="align: center"]17
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Apr
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD="align: center"]May
[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]19
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Jun
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD="align: center"]Jul
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Aug
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Sep
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD="align: center"]Oct
[/TD]
[TD="align: center"]11
[/TD]
[TD="align: center"]20
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
[TR]
[TD="align: center"]Nov
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]14
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD="align: center"]Dec
[/TD]
[TD="align: center"]19
[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]31
[/TD]
[/TR]
</tbody>[/TABLE]


I want pivot table to show the cumulative row sum & cumulative row sum percentage as shown below

[TABLE="width: 148"]
<tbody>[TR]
[TD]

cumulative row sum​

​

[/TD]
[TD]

cumulative row sum percentage​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

14​

​

[/TD]
[TD]

45%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

31​

​

[/TD]
[TD]

53%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

48​

​

[/TD]
[TD]

53%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

62​

​

[/TD]
[TD]

52%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

74​

​

[/TD]
[TD]

49%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

90​

​

[/TD]
[TD]

50%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

101​

​

[/TD]
[TD]

48%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

112​

​

[/TD]
[TD]

46%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

128​

​

[/TD]
[TD]

47%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

139​

​

[/TD]
[TD]

46%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

155​

​

[/TD]
[TD]

46%​

​

[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD]

174​

​

[/TD]
[TD]

48%​

​

[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 148"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Thanks

 

[zuriqi]

To make is more clear:

The "

cumulative row sum" in the 2nd table is the cumulative sum of "Pass" column in 1st table.
The "cumulative row sum percentage" column in 2nd table is the ration of cumulative "Pass" to cumulative Total. where total is sum of "Pass" and Failed".​