Calculated Field in a Pivottable

  • Thread starter Thread starter aiddy1971
  • Start date Start date
A

aiddy1971

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?
 
Herbert, Thank you for this, I will have a look from home later -
only have Excel 2002 in the office. Is what you have suggested
possible in older versions?
 
Hi Herbert,

That is exactly what I need, thank you - now if I can only achieve the
same in Excel 2002.

Adrian
 
Back
Top