Microsoft Office Tutorials and References
In Depth Information
Figure 18-29: This pivot table is grouped by hours.
This workbook, named time based grouping.xlsx, is available at this topic's website.
Following are the settings I used for this pivot table:
• The Values area has three instances of the Reading field. I used the Data Field Setting dialog box (the Sum-
marize Values By tab) to summarize the first instance by Average, the second instance by Min, and the third
instance by Max.
• The Time field is in the Row Labels section, and I used the Grouping dialog box to group by Hours.
Creating a Frequency Distribution