Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculated Field in PivotTable | Excel Discussion (Misc queries) | |||
Calculated field - pivottable | Excel Discussion (Misc queries) | |||
#VALUE! in PivotTable using Calculated Field | Excel Discussion (Misc queries) | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions |