Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Remove subtotal in pivot tbl (Excel 2003 / SP2)

    Why can't I remove the subtotals from the row section of the pivot table? What am I doing wrong here?!?!?!?
    Attached Files Attached Files
    thanks
    christine

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove subtotal in pivot tbl (Excel 2003 / SP2)

    Click on the field that has the subtotal. Right click. Choose "Field Settings". Subtotals - click on "None".

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Remove subtotal in pivot tbl (Excel 2003 / SP2)

    Oh, hello Stupid. I can't believe i was looking all around the field setting and kept overlooking the Subtotals section. Boy, how dumb! Thanks for your help!
    thanks
    christine

Posting Permissions

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