Managing Data with Microsoft® Excel

Preparing Data for Pivot Tables

There are some special considerations to keep in mind when you specify the records you want to use in pivot tables. These issues don't apply to external data ranges unless you then use the external data range as the source for a pivot table. The idea is to avoid putting records into the pivot table if they contain null values in a field that you want to use to group records.

Grouping on Date and Time Fields

It often happens that you want to analyze data in a pivot table using a date or time of day as a row, column, or page field. For example, you might want to know the average number of traffic accidents during each hour of the day or during each day of the week.

When the time and/or date that something occurs ...