Microsoft® Excel® 2010 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 in a variety of ways—one of which is new in Excel 2010.

Filtering with the Report Filter Axis

Figure 23-4, on page 779, shows a PivotTable in which one field, Category, appears on the Report Filter Axis. To create this table, we simply dragged the Category field from the PivotTable Field List to the Report Filter area below the field list. With the table arranged in this manner, we can focus ...