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

PivotTable filters

  1. Click the filter button on the field you wish to filter
  2. Applying a filter
  3. All the records are shown by default. Click the checkbox against the records you do not wish to see.
  4. Records with a checkmark next to them will be shown and those without are hidden.

  5. Click Ok
  6. 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
  2. Sort options are provided along with the filter options

  3. Select the desired sort option

Follow us on

Facebook  Twitter  You Tube