+ Reply to Thread
Results 1 to 3 of 3

Pivot Table question, may be a simple one!

  1. #1
    Registered User
    Join Date
    01-23-2012
    Location
    Essex
    MS-Off Ver
    Excel 2010
    Posts
    21

    Pivot Table question, may be a simple one!

    Just a quick question, I have a pivot table, which due to the data inside, I have 7 different report filters needed to be used.

    Because of the way I've sorted the data/formula's, it means I only ever need 1 report filter set to true (only options are true/false or all) at a time.

    Is there a simple way that, if I turn 1 filter on (to true), the others automatically return to off (all) ???

    It may be really simple but I just have no clue if its even possible.

    Thanks in advance

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Pivot Table question, may be a simple one!

    hi PhoenixJR, i'm wondering how you are doing it at the moment. let's say if the report filter contains A-G. If you want to select B, you drop the Report filter, deselect "All" & choose "B". There is a quick way to churn out all 7 reports though:
    Click on the pivot table & go to the Options tab. you should see an "Options" button on the extreme left of the screen. click on the downward triangle beside it & choose "Show Report Filter Pages..." & click OK.

    let me know if that helps

  3. #3
    Registered User
    Join Date
    01-23-2012
    Location
    Essex
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: Pivot Table question, may be a simple one!

    Hmmmm i like it, it works well for what it does.

    But ideally, I dont just have 1 report filter. I have 7 different ones.

    But with only the need to have 1 turned on at once.

    (if 2 are turned on at same time, the results are always empty).

    Thanks though

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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