Filtering a PivotTable by rule


show more Filtering a PivotTable by rule 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 by rule

PivotTables help you summarize large amounts of data, but you can always limit the data that appears by creating a filter. If the data you want to display in your PivotTable fits the rule, such as all values greater than 1000, you can define that rule and use it to filter your PivotTable. To filter a PivotTable using the values in the field, you can click any cell in the body of the PivotTable and then go over to the PivotTable Field List task pane and position your mouse pointer over the field that you want to filter by. In this case, I want to filter by month, so I will move the mouse pointer over that field, and then on the right edge click the down arrow that appears and you can select the type of filter that you want to create.

You can create two different types of filters: a label filter or a value filter. As the name imply,s a label filter lets you filter on the values in the label area. So for example, in this PivotTable we have Years, 2009, Quarters, 1 2 3 and 4, and then Month...

Filtering a PivotTable by rule
Video duration: 2m 56s 3h 43m Intermediate

Viewers:

Filtering a PivotTable by rule 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 ...