To focus on a smaller portion of a large amount of your PivotTable data for in-depth analysis, you can filter the data. There are several ways to do that. Start by inserting one or more slicers for a quick and effective way to filter your data. Slicers have buttons you can click to filter the data, and they stay visible with your data so you always know what fields are shown or hidden in the filtered PivotTable.

Slicer choices with the multi-select button highlighted

Filter data in a PivotTable

  1. Select a cell in the PivotTable. Select Analyze > Insert Slicer Slicer .

  2. Select the fields you want to create slicers for. Then select OK.

  3. Select the items you want to show in the PivotTable.

Filter data manually

  1. Select the column header arrow  Filter drop-down arrow  for the column you want to filter.

  2. Uncheck (Select All) and select the boxes you want to show. Then select OK.


Source: Microsoft