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, do the following:
1.Select in the column header.
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 to apply the filter. Or click to cancel the selection and close the filter setting window.