Filtering a PivotTable field by selection


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

You can use PivotTables to summarize huge data collections, but many times you will want to limit the data displayed within 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. There are three main ways to filter the contents of the PivotTable field: by selection, by rule, and by search term. Filtering by selection means you display a list of values in the field and select the values you want to display.

So for example, let's say that I have the results here in those PivotTable that displays sales for four different regions, East, North, South, and West, and let's say that I only want to display those values for the North and West regions. To do that I'll click any cell on the PivotTable and then over in the PivotTable Field List I move my mouse pointer over the header of the field that I want to...

Filtering a PivotTable field by selection
Video duration: 2m 59s 3h 43m Intermediate

Viewers:

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