Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table Totals (2003)

    Hi, I have a pivot table set up as following:

    Rows: Cost Ctr, Cost Ctr name, Cost Element, Cost Element Name
    Column: Month
    Data: Sum of Amount

    It totals for Cost Ctr, Cost Ctr name, and Cost element. I only want a total for Cost Ctr. Is this possible, and if so how do I do this?

    Thanks!!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table Totals (2003)

    Right click the totals you don't want and select Hide from the popup menu.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table Totals (2003)

    YTM - You're the Man as usual.

    Many thanks!

    Mitch

Posting Permissions

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