You have perfected your data analysis with a pivot table and you are about to share with other users. Slicers make Pivot Tables easier for other users to filter data in the table.
Slicers are a pop-up dialog box which allow the user to click on button to quickly filter the data.
- Click in your Pivot Table.
- From the Pivot Table Tools > Analyze toolbar, Click Insert Slicer.
- Select the fields to provide a filter.
4. To filter select the value on the slicer dialog box.
To select multiple values, click on the Multi-Select icon then click on the desired values. To clear the filter, select the Clear Filter icon with the red x to display all values.