View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt M HMS
 
Posts: n/a
Default 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