+ Reply to Thread
Results 1 to 2 of 2

pivot table - hide details but show subtotal for calculated field

  1. #1
    tenneym
    Guest

    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. #2
    Debra Dalgleish
    Guest

    Re: pivot table - hide details but show subtotal for calculated field

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1