Slicers make it really easy to filter data in a pivot table. Adding a Slicer is similar to adding a second Page field (Report Filter), but it's even easier to use.
To add a Slicer to a pivot table:
- Select any cell in the pivot table.
- On the PIVOTTABLE TOOLS ANALYZE tab (PivotTable Tools Options tab in Excel 2007/2010), in the Filter group (Sort & Filter group in Excel 2007/2010), click the Insert Slicer command (and then select Insert Slicer in Excel 2007/2010):
- In the Insert Slicers dialog box, check the field or fields (Yes, you can create multiple slicers at once!) to use to "slice" your data and click OK:
- To use the Slicer, simply select one of the fields in the Slicer to filter your data by that field: