+ 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

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  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