Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
CLEAN UP Close the Creating workbook, saving your changes if you want to.
Filtering, showing, and hiding
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 that represents the distribution center, date, month, week, weekday, day, and
volume for every day of the year.