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.
> 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.
Excel FAQ, Tips & Book List