Filtering using report filter fields


show more Filtering using report filter fields provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Filtering using report filter fields

Whenever you add a field to a Pivot Table's column area, or row area, you change the Pivot Table's structure by adding a layer of detail. But suppose you have a great Pivot Table layout and you want to filter the Pivot Table using the values in a field that doesn't appear in the arrangement. For example, you might want to filter monthly sales data by Quarter, but without having the Quarter field change the Pivot Table's layout. How do you filter the Pivot Table using the Quarter field? The answer is that you add the Quarter field to the Page Field area, and create the filters as normal. In this Pivot Table, I have the data arranged by Year, and then by Month.

I have the Quarter field available to me, but I am not using it to change the structure the Pivot Table. If I want to filter the Pivot Table using the values in Quarter, I can do so by moving the Quarter field to the Page Fields area. I just added the Quarter field to the Pivot Tables arrangement, but I did not chang...

Filtering using report filter fields
Video duration: 3m 3s 1h 7m Intermediate

Viewers:

Filtering using report filter fields provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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