Slicers were introduced by Microsoft in Excel 2010 for regular Pivot Tables, and are also available in PowerPivot.
A slicer is an 'on demand' filter that simply allows you to click on an item(s) to immediately filter your information. Combine several slicers for multi-filter analysis.
In this example, we have three stages.
If you choose one customer, then only the items belonging to that customer will show - and be available in the Item Filter.
Then choose one or multiple items.
You can reset your slicer:
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/3460/using-slicers-filters