Using Slicers (Filters) | CLEARIFY

Slicers

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.

• 'Raw' information.
• Use the first slicer - Customer Name - to show just the one customer.
• Use the second slicer - Item Name - to further filter by a particular item

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: