Filtering a PivotTable with report filter fields


show more Filtering a PivotTable with report filter fields provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Filtering a PivotTable with report filter fields

Whenever you add a field to a PivotTable's column area or row area, you change the PivotTable structure by adding a layer of detail. But suppose you have a great PivotTable layout and want to filter the PivotTable using the values in a field that doesn't appear within the arrangement. For example, you might want to filter monthly sales by quarter, but without having the Quarter field change the PivotTable's layout. How do you do that? Well the answer is that you add the quarter field to the Report Filter field area and create the filters as normal.

So the first thing you do is click any cell new PivotTable and make sure that the PivotTable Field List task pane is displayed and in the bottom of the PivotTable Field List you see several different areas. There is the Column Labels area, the Row Labels area, and the Values area, which allow you to create the structure of the PivotTable. The area we haven't covered yet is called the Report Filter area. As the name implies you ...

Filtering a PivotTable with report filter fields
Video duration: 5m 2s 3h 43m Intermediate

Viewers:

Filtering a PivotTable with report filter fields provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...