User:Antonio.remedios/PdfTestPage

Cascading and Advanced Slicers

Slicers have a filter area in their definition, which can be used to restrict the members returned based on the presence of data. The example below shows the design for a slicer for ‘Product Model Categories’ which is being filtered on ‘Geography’ based on what has been selected in the slicer at Sheet1!$C$3.

AdvancedSlicer1.png

[1]