Microsoft Office Tutorials and References
In Depth Information
Grouping Pivot Table Items
Figure 18-26: The pivot table, after grouping by years and months.
If you select only Months in the Grouping list box, months in different years combine
together. For example, the January item would display sales for both 2005 and 2006.
Figure 18-27 shows another view of the data, grouped by quarter and by year.
Grouping by time
Figure 18-28 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.