View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aiddy1971 aiddy1971 is offline
external usenet poster
 
Posts: 2
Default Calculated Field in a Pivottable

I have a pivottable with 2 row fields showing a structure heirarchy,
a
column field showing status and a data field showing headcount.

What I would like to do is add a calculated field to show the
percentage of headcount that have a status of complete compared to
the
subtotal for that tier of the heirarchy. If possible I would like to
include this as a single calculated value as an additional row field
as opposed to adding a second data field and using the '% or row'
option.


Is there a way of doing this?