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?
 
Hi,

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