Try it!
Filter the data to focus on a smaller portion of your PivotTable for an in-depth analysis.
Filter data in a PivotTable
-
Select a cell in the PivotTable.
-
Select Analyze > Insert Slicer .
-
Select the fields you want to create slicers for.
-
Select OK.
-
Select the items you want to show in the PivotTable.
Filter data manually
-
Select the column header arrow for the column you want to filter.
-
Uncheck (Select All) and select the boxes you want to show.
-
Select OK.