Excel > Excel 2003 Advanced > PivotTables 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 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

Pivottable filters

  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.
  3. Records with a checkmark next to them will be shown and those without are hidden.

    Applying a filter
  4. Click Ok
  5. The field is filtered only displaying the desired data.

Sorting a PivotTable

  1. Select a cell in the PivotTable containing data for the field you wish to sort by
  2. Click either the Sort Ascending or Sort Descending buttons on the Standard toolbar

Follow us on

Facebook  Twitter  You Tube