calculated field - Pivot Table

[Matt M HMS]

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]

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