Page 143 - Excel Data Analysis

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

WORKING WITH PIVOTTABLE REPORTS 7

If the list of available items is longer than the If you filter multiple fields, the values in the Data Area
space allotted for it, a scroll bar displays on update automatically to reflect the changes. Only
the right side so you can scroll through the records that match each of the field filters display on
list. You can resize the list box by dragging on the PivotTable. For example, if you filter the Row field
one of the sides so that you can view more of to display only the items January and February and
the available items. filter the Column field to display the items Texas and
Florida, only values that match these criteria display in
If you resize the list box and click OK, Excel the Data area. Keep in mind, filters do not remove the
remembers the size and displays the list box data values from the PivotTable report, they simply
that same size the next time you view the hide your data. If you select different items on the list
field values.
box for a field, Excel updates the PivotTable report
immediately to show the new selections.

Smith

■ Excel removes all of the ‹ Click each item you want ■ The PivotTable updates
checkmarks. on the PivotTable. automatically to display only
the selected items.
› Click OK.

129