Excel > Excel 2007 Advanced > PivotTable and PivotCharts

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

1. Click the filter button on the field you wish to filter
2. All the records are shown by default. Click the checkbox against the records you do not wish to see.

Records with a checkmark next to them will be shown and those without are hidden.

3. Click Ok

The field is filtered only displaying the desired records.

Sorting a PivotTable

1. Click the Filter button for the field you wish to sort by

Sort options are provided along with the filter options

2. Select the desired sort option

Updating a PivotTable Grouping PivotTable data

Guides