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.
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.
Bookmarks