Pivot table cumulative row sum percentage

zuriqi

Board Regular
Joined
Dec 8, 2008
Messages
79
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

Board Regular
Joined
Dec 8, 2008
Messages
79
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".​
 
Last edited:

Forum statistics

Threads
1,078,275
Messages
5,339,204
Members
399,287
Latest member
ossa

Some videos you may like

This Week's Hot Topics

Top