Microsoft® Office Excel® 2007 Inside Out

Filtering PivotTable Fields

Filtering a field lets you focus your table on a subset of items in that field. You can filter on the basis of the field’s own content (only the Children and Young Adult categories, for example) or on the basis of values associated with the field (for example, the three categories with the best overall sales). You can apply filters either in the PivotTable Field List window or on the PivotTable. If you’re working with a large external data source and you need only a subset of the data, you can save yourself some time by filtering in the PivotTable Field List window before you execute the query and create the table.

To filter in the PivotTable Field List window, select the heading for the field you want to filter, and ...