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

Count of Date	Column Labels
Row Labels	Pass	Failed	Grand Total
Jan	14	17	31
Feb	17	11	28
Mar	17	14	31
Apr	14	16	30
May	12	19	31
Jun	16	14	30
Jul	11	20	31
Aug	11	20	31
Sep	16	14	30
Oct	11	20	31
Nov	16	14	30
Dec	19	12	31

<tbody>
</tbody>

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

cumulative row sum​ ​	cumulative row sum percentage​ ​
14​ ​	45%​ ​
31​ ​	53%​ ​
48​ ​	53%​ ​
62​ ​	52%​ ​
74​ ​	49%​ ​
90​ ​	50%​ ​
101​ ​	48%​ ​
112​ ​	46%​ ​
128​ ​	47%​ ​
139​ ​	46%​ ​
155​ ​	46%​ ​
174​ ​	48%​ ​

<tbody>
</tbody>

<tbody>
</tbody>

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".​