Microsoft Office Tutorials and References
In Depth Information
Filtering, Showing, and Hiding PivotTable Data
PivotTables often summarize huge data sets in a relatively small worksheet. The more
details you can capture and write to a table, the more flexibility you have in analyzing
the data. As an example, consider all the details captured in a table in which each row
contains a value representing the distribution center, date, month, week, weekday, day,
and volume for every day of the year.
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.”