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
0
tenneym (1)
2/7/2005 8:47:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
284 Views

Similar Articles

[PageSpeed] 53

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

0
dsd1 (5911)
2/9/2005 3:07:17 AM
Reply:

Similar Artilces: