Excel 2010 and Excel 2013 makes it possible to insert slicers to quickly and easily filter pivot tables. However, using the report filter gives the exact same result.
To insert a slicer, execute the following steps :
- Click any cell inside the pivot table. The PivotTable Tools contextual tab activates.
- On the Options tab, insert a slicer.
- Check Category and click OK.