Subtotaling a calculated field in a pivot table
 

I have this pivot table with a calculated field dividing the 1st column
into the 2nd. When it subtotals, it always uses the sum of the 2nd
column which is not what i need as as you can see it gives a much
smaller %. 28915/105503 is not 5.48%. I need it to divide the
subtotal of the 1st column into the 2nd same as above. I tried making
the subtotal of the 2nd column to show MAX thinking that would override
always using the sum. I'm stumped.

[image: http://www.photodump.com/direct/mpcl...ivottable.jpg]


--
stu_padassol
------------------------------------------------------------------------
stu_padassol's Profile: http://www.excelforum.com/member.php...o&userid=36840
View this thread: http://www.excelforum.com/showthread...hreadid=567595