Pivot table use a large set of data to create detailed summaries. When you adjust pivot table settings, filters can be added to pivot tables to quickly filter the data. Columns containing a filter display a filter drop-down arrow in the column header.
To filter data in a pivot table:
1.Select in the column heading.
2.In the settings window that opens, select the field whose values you want to filter and check the boxes next to the values you want to display in the table. Repeat the operation for all required fields.
3.Click the OK button to apply the filter. Or click Cancel to cancel the selection and close the filter setting window.