Microsoft Office Tutorials and References
In Depth Information
Grouping Items by Date in a Pivot Table
Figure 171-4: The pivot table, after grouping by months and years.
Notice that the Grouping dialog box contains other time-based units. For example, you can group
the data into quarters. Figure 171-5 shows the data grouped by quarters and years.
Figure 171-5: The pivot table, after grouping by quarters and years.