Excel Pivot Tables Custom Row Totals

[Russ Reich]

I recently set out to make a very dynamic pivot table featuring multiple variables. The example below shows team data by status of testing. The main thing I need is to be able to see the grand total and also another field showing the % Complete dynamically in the pivot table. The goal is to refresh the pivot table from our server and have it seamlessly show us the below. The problem is the last cell in the total field (highlighted in red) for the calculated item % Complete is a total of the percentages. It needs to be ((passed + passed with work around) / (Grand total)) respectively for the last cell ((7662+157) / 9216) = 85%.

I un-selected the row totals and added two calculated items to show row totals as grand total and % complete as ((passed + passed with work around)) / (Grand total)).

Any thoughts or ideas would be greatly appreciated. I think I have exhausted the pivot table options is there a way to add VBA to make this work?

	Column Labels
Row Labels	Blocked	Failed	No Run	Not Completed	Passed	Passed with work-around	Grand Total	% Complete
Team 1		2	15	3	237	14	271	93%
Team 2					27		27	100%
Team 3		6	21	18	193		238	81%
Team 4			5		79		84	94%
Team 5			2	11	4		17	24%
Team 6		4	1	2	260		267	97%
Team 7	8	59	408	117	3065	92	3749	84%
Team 8		33	473	53	869	22	1450	61%
Team 9		3	34	10	413	2	462	90%
Team 10		4	31	14	1969	23	2041	98%
Team 11		1	21	10	478	4	514	94%
Team 12		8	14	6	68		96	71%
Grand Total	8	120	1025	244	7662	157	9216	986%

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>