Drag a field to the Filters area in the PivotTable Fields pane.
The filter field appears at the top of the PivotTable. The text (All) is displayed so you know the data is not currently being filtered.
Click the list arrow for the field you’ve added as a filter.
A list of sorting and filtering options appears. The items available in the menu will differ based on the field you’ve added as a filter. Additionally, a Search field appears at the top of the filter list. If desired, manually type the criteria by which you want to filter.
You can also filter the row or column headings in a PivotTable by clicking the Row Labels or Column Labels list arrow and selecting only the value(s) you want to display.
Select the item(s) you want to use as a filter.
The PivotTable updates to display only the values that meet the filter criteria.