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 Report Filter area filters the whole table. You can also filter the row and column fields in a PivotTable to only display data that meets your criteria.
To filter the PivotTable using the Report Filter, you first need to drag a field into the Report Filter
- 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 records.
Sorting a PivotTable
- Click the Filter button for the field you wish to sort by
- Select the desired sort option
Sort options are provided along with the filter options