Sorting and filtering a PivotTable
You can sort and filter the data in a PivotTable much like you would a normal data range.
Filter a PivotTable
The Page area filters the whole table. You can also filter the row and column fields in a PivotTable to only display the data that meets your criteria.
To filter the PivotTable using the Page area, you first need to drag a field into the Page area
- Click the filter button on the field you wish to filter
- All the records are shown by default. Click the checkbox against the records you do not wish to see.
- Click Ok
Records with a checkmark next to them will be shown and those without are hidden.
The field is filtered only displaying the desired data.
Sorting a PivotTable
- Select a cell in the PivotTable containing data for the field you wish to sort by
- Click either the Sort Ascending or Sort Descending buttons on the Standard toolbar