Microsoft Office Tutorials and References
In Depth Information
Tip In Excel 2003 and earlier versions, this area was called the Page Field area.
When you click the filter arrow of a field in the Report Filter area, Excel displays a list of
the values in the field. When you click the filter arrow, you can choose to filter by one
value at a time. If you’d like to filter your PivotTable by more than one value, you can
do so by selecting the Select Multiple Items check box.
If your PivotTable has more than one field in the Row Labels area, you can filter values
in a PivotTable by hiding and collapsing levels of detail within the report. To do that,
you click the Hide Detail control (which looks like a box with a minus sign in it) or the
Show Detail control (which looks like a box with a plus sign in it) next to a header.