Delay Filter Action

Sometimes you may want to setup all the filter criteria first then apply all the filters at once, this can be done by switching on the Passive Slicer feature under Pivot Table Detail Settings dialog.

Once enabled the Apply Filters command will show up whenever you make a change to the slicer criteria. 

Now you can set all your filters first then select Apply Filters to apply all criteria in one shot. 




Have more questions? Submit a request


Please sign in to leave a comment.