Page 142 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 128

EXCEL DATA ANALYSIS

FILTER A FIELD

ou save time and effort analyzing your data by column. If you do not see the appropriate item on the list,
filtering each field on a PivotTable to only display you must verify your original data values. If you created
Y records that meet specific criteria. By default, when your PivotTable report from another Excel worksheet, you
you add a field to a PivotTable report, all items display in need to check the original values on the worksheet. If you
the row or column. You can filter the fields to display only used an external database, you can review the data by
certain items, or any combination of the items that display importing it into another worksheet. See Chapter 5 for
on a list in the Row and Column areas. For example, if the information on working with external databases.
Row area contains a Cities field, you can filter the field to If you assign a field to the Page area, the field in the top left
only display records for specific cities, such as Dallas and corner of the PivotTable, you can either select all items or
Houston. You must select at least one item for each field. If just one individual item. If you specify a single item for the
you try to close the list without selecting an item, an error field, only records that contain that item value display on
message displays.
the entire PivotTable. See "PivotTable Basics" for more
The items that display for each field come from the data information about the Page area and other elements of a
you used to create the PivotTable report. If you created PivotTable.
your PivotTable report from an Excel list, the items on the
list are the actual labels from the corresponding Excel

FILTER A FIELD

⁄ Click the down arrow ■ A list displays the available ¤ Click the Show All option
next to the field you want to items. to remove the selection.
filter.

128