O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required