Microsoft Office Tutorials and References
In Depth Information
Tip 81: Grouping Items by Date in a Pivot Table
Figure 81-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 81-5 shows the data grouped by quarters and years.
Figure 81-5: The pivot table, after grouping by quarters and years.