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?

 

[Shane Devenshire]

Hi,

Why don't you show us a sample of the data and what you would like the pivot
table to look like.

 

[aiddy1971]

Hi Shane,

An example data set can be found here: http://www.aiddy.co.uk/Example.xls

What I'm trying to achieve is the yellow column that shows the %age
complete for each row.

Hope this makes sense.

Cheers, Adrian