Calculated Field in a Pivottable

[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 Seidenberg]

Excel 2007 PivotTable
Percentage with multiple row field tiers
http://www.mediafire.com/file/mxyvrjrumzm/06_17_09.xlsx

 

[aiddy1971]

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?

 

[aiddy1971]

Hi Herbert,

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

Adrian