Microsoft Office Tutorials and References
In Depth Information
Figure 18-28: This pivot table shows sales by quarter and by year.
Grouping by time
Figure 18-29 shows a set of data in columns A:B. Each row is a reading from an instrument, taken at one-
minute intervals throughout an entire day. The table has 1,440 rows, each representing one minute. The pivot
table summarizes the data by hour.