Using a pivot table calculated value in a formula

[robertdseals]

Hello,
I have a pivot table with one of the "values" being an average of a daily dollar amount (it's calculated in the "values" section of the pivot table field list. I would like to have another column that show the percent to subtotal of this field.

Bank		lines		CIPD	% of CIPD Subtotal
501		5		2183.29	100.00%	S/B 1027.25%
		1		1705.95	100.00%	S/B 99.43%
		1		2675.26	100.00%	S/B 155.92%
		1		804.11	100.00%	S/B 46.86%
		5		1495.01	100.00%
		5		1829.82	100.00%
		5		951.79	100.00%
		5		1533.67	100.00%
501 Total				1715.71	4.18%

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

 

[ghrain22]

I'm not sure that I follow. But it seems to me that you could just add your calculated field a second time and use "summarize values as" > "% of parent total".

 

[robertdseals]

Thanks for the reply. What I'm trying to do is find out what the percent of that amount is to the subtotal amount. I wish the pivot table would allow me to calculate a calculated field instead of just "fields" in the pivot table.