Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table - hide details but show subtotal for calculated field
i have a pivot table that calculates resource availability. each resource
may work on multiple projects, and each of these projects require a certain number of hours. the grouping is by person, by project. for each person, i need to show hours allocated toward each project (detail) and then total number of hours allocated (subtotal). i also need to show a calculated field of % hours available (subtotal only) for each person. John project 1 30 hours (detail) project 2 15 hours (detail) Sum of hours 45 hours (subtotal) Caculated field (1-sum(hours)/40) (subtotal) how can i show this calculated field only as a subtotal but hide its detail? thanks much. -- mt |
#2
|
|||
|
|||
You can't show a field only as a subtotal, with no detail. You could
hide the data by formatting the cells with white font. tenneym wrote: i have a pivot table that calculates resource availability. each resource may work on multiple projects, and each of these projects require a certain number of hours. the grouping is by person, by project. for each person, i need to show hours allocated toward each project (detail) and then total number of hours allocated (subtotal). i also need to show a calculated field of % hours available (subtotal only) for each person. John project 1 30 hours (detail) project 2 15 hours (detail) Sum of hours 45 hours (subtotal) Caculated field (1-sum(hours)/40) (subtotal) how can i show this calculated field only as a subtotal but hide its detail? thanks much. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |