calculated field - Pivot Table
 

Is it possible to add a calculated field into a Pivot Table where the Calced
field is a percentage of the subtotal for a column. For column A, I have five
values; four of these values are subtotaled to equal 20:

A
2
5
4
9
_
20
12
_
32

How do I add a calculated field (or item) which will show 2/20=10%,
5/20=25%,...and finally 12/32=37.5%

thank you
Matt

calculated field - Pivot Table
 

You can't divide by a subtotal amount in a pivot table. By arranging the
fields differently you may be able to use the % of column or % of row
custom calculation. Or, perform the calculations outside of the pivot
table, using the GetPivotData function to extract the data.

Matt M HMS wrote:
Is it possible to add a calculated field into a Pivot Table where the Calced
field is a percentage of the subtotal for a column. For column A, I have five
values; four of these values are subtotaled to equal 20:

A
2
5
4
9
_
20
12
_
32

How do I add a calculated field (or item) which will show 2/20=10%,
5/20=25%,...and finally 12/32=37.5%

thank you
Matt



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html