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 ...

Get 2007 Microsoft® Office System Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.