Pivot Table question, may be a simple one!

**PhoenixJR** · 06-26-2012, 09:16 AM

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

**benishiryo** · 06-26-2012, 09:59 PM

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

**PhoenixJR** · 06-27-2012, 09:28 AM

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