Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up

The core benefit of this function would be to reduce the amount of physical space occupied by static slicers on a crowded pivot table page. Slicers are superior to report filter boxes since the indicate which field parameters are not available due to other filtering actions on the same pivot.

A VBA-enabled file is provided as an example, which is also published at www.contextures.com