Pivot Chart \ Pivot Table show a cumulative Overall percentage for multiple months.

[Poduska]

I have a working Pivot Chart based upon a Pivot Table.

Sorry I could not get an image of my chart to load.

Background - there are multiple items each month which were either completed "ON Time" or Late.
"ON Time" and Late are stacked bars and the % On Time is a line using the secondary Y axis due to the small % values.

SAMPLE DATA
[TABLE="width: 356"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Row Labels
[/TD]
[TD] OnTime
[/TD]
[TD]% OnTime[/TD]
[TD]Late[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]44.6%[/TD]
[TD="align: right"]41[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Jun[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]40.0%[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Aug[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]60.0%[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Dec[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]49.5%[/TD]
[TD="align: right"]46[/TD]
[/TR]
</tbody>[/TABLE]


So for April there were a total of 74 items, 33 were "On Time" hence 44.6% "On Time" performance.

So far so good.

However,
The percentage each month needs to be CUMULATIVE over all previous months and not simply the one month.
So May percentage should be 37 "On Time" over 78 total so 47.8% ON time and not 100% which is the % ON Time for May only.

I can create a Running Total for "On Time" and Late in the pivot table but they then show on the chart and I cannot calculate against the TOTAL of the Running Total for all months.

Any ideas how to create a cumulative Percent over many months?


-- removed inline image ---

 

[mole999]

for display I would consider using some cells to take the values you want and then get your total to dispaly, then over the chartt add a text bot that references your cell answer