Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding a Pivot Table Field button (Excel 2000)

    If I group some fields in a pivot table, I can rename the group name by over typing it with something new, however; I do not need the additional field button it also adds. If I remove this field button, it removes the group! Is there a better way to not have this button printed other than copy and paste special the pivot table so that it is no longer a pivot table and then delete the bit I don't want.

    In the example attached, I would want to lose the button that says John's Team without losing the group. Also, you get repeated names at the top which I cannot get rid of.
    Attached Files Attached Files
    Neil Eustice
    Woody Worshipper

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    Hi:
    Could you restate your problem and include a descriptionnof what you did and the way you would like the table to look. Also, without a sample of what the source data looks like, we are limited in being able to respond with options.
    Thanks

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    OK, from the top then. I include a cut down version of the data. Open it and follow these steps.
    From Data sheet, Data, Pivot Table, Next, Next, Finish
    Drop Consultant in the column field
    Drop Project in the Row field
    Drop Profit in the Data field
    Highlight Bert, Bill and Jane
    Data menu, Group and outline, group
    Overtype Group 1 with "Jane's Team"
    Right click on Consultant 2, Field settings and rename Consultant 2 "Jane's Team".
    I (and you) now have the problem of duplicated names above John, Julia etc which I would like to hide, and I also would like to hide the "Jane's Team" button as it is not needed on the print out (it already says it below the field button).
    Hope this helps.
    Attached Files Attached Files
    Neil Eustice
    Woody Worshipper

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    I am sorry but I still don't get it. Like where does Consultant 2 come from? The data only has 1 column for consultant..

  5. #5
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    When you group and outline, the system creates the second group automatically based on the selection you had highlighted. That is the problem. I want the group, so that I can show and hide it at will, but don't want the duplication of headings.
    Neil Eustice
    Woody Worshipper

  6. #6
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    Hi there,

    Is this maybe what you are looking for. (see attachment sheetivot test)

    Regards
    Attached Files Attached Files

  7. #7
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    Sorry Rene,

    What appears to be in your attachement is the pivot table before the grouping is done. I want the grouping, I just don't want the additional duplication of headings. I have attached another spreadsheet with the sort of thing I want. The first one is a real pivot table and gets rid of the duplicated headings by virtue of the fact that I have grouped every name. But I don't want to group all the names. I just want to group a set of names and have the other duplication dissappear.

    I have shown in picture form the sort of thing I want in the second pivot table - the trouble being of course, it is not a real pivot table. I think what I want may be impossible to do via pivot tables; if so, don't worry.

    Neil
    Attached Files Attached Files
    Neil Eustice
    Woody Worshipper

  8. #8
    Star Lounger
    Join Date
    Apr 2001
    Location
    SOUTH AFRICA
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    Hi Neil,

    This attachment is the best I can suggest. The teams can be selected with the dropdown arrow on the 'TEAMS' button.
    Attached Files Attached Files

  9. #9
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding a Pivot Table Field button (Excel 2000)

    Thanks for trying Rene, but the page button doesn't solve my layout problem. I think it looks like the answer is "You can't have everything you want" when it comes to pivot tables. Don't worry, I will go on to a new problem and just put the picture in my report instead.

    Cheers.
    Neil Eustice
    Woody Worshipper

Posting Permissions

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