Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a fairly complex spreadsheet that utilises pivot table subtotals. The problem is that I only want to display the subtotal in a section where there is more than one entry. Is there a way that this can be achieved?

    I have attached a simple example spreadsheet - the pivot table is in the sheet called Pivot (say what you see!!) and you will see that even though there is only one item listed for the months of April and June, that the subtotal appears and I really don;t need it! The display for May is fine since there is more than one item to be totalled. Anyone have any ideas how I can go about this?

    Thanks in advance.

    Alba
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    What you want is not possible, as far as I know. Sorry!


  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How about adding a intermediate column to filter out the rows to hide (see attached)...

    Steve
    Attached Files Attached Files

  4. #4
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    this one is excellent, give me an idea for case of mine.

    and thinking would be good if there is option for someone to indicate how useful a thread?

    thanks

  5. #5
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Absolutely Stunning!

    I didn't think that it would be possible to do this within the Pivot table itself and I thought that it may need a solution that was slightly off the wall. It works perfectly - however one wee thing...ideally I would want the True/False column to be hidden and for the filter to automatically update as the pivot updates. Its not a biggie, but would just be the icing on the cake..

    Thanks again - you're an absolute star!

    Alba

Posting Permissions

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