Filter a PivotTable Report in Excel for Mac 2011


show more Filtering a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Filtering a PivotTable report

PivotTables can summarize huge data collections, but many times you'll want to limit the data displayed in a given category. For example, if your company's operations are divided into four regions, you might want to display just those results for one of the regions. You can limit the data displayed in a PivotTable by creating a filter. Earlier in this course, I showed you how to filter a data list and also an Excel table. You can use those skills to create selection filters, and also to filter by rule. The skills are exactly the same. In this movie, I'm going to show you a way of filtering that is unique to a PivotTable, and that is by using the Report Filter field.

If you look over in the PivotTable Builder, you'll see that there are four areas: the Values area, which is the interior of the PivotTable; Row Labels, which provides the rows labels here; Column Labels, which provides structure and value for the columns of your PivotTable; but we haven't talked about the ...

Filtering a PivotTable report
Video duration: 2m 46s 6h 32m Beginner

Viewers:

Filtering a PivotTable report provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

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