Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
Each column, in turn, contains numerous values: there are nine distribution centers, data
from two years, 12 months in a year, seven weekdays, and as many as five weeks and 31
days in a month. Just as you can filter the data that appears in an Excel table or other data
collection, you can filter the data displayed in a PivotTable by selecting which values you
want the PivotTable to include.
SEE ALSO For more information on filtering an Excel table, see “Limiting data that appears
on your screen” in Chapter 5, “Focusing on specific data by using filters.”
To filter a PivotTable based on a field’s contents, click the field’s header in the Choose Fields
To Add To Report area of the PivotTable Fields pane. When you do, Excel displays a menu of
sorting and filtering options.