Microsoft Office Tutorials and References
In Depth Information
Tip 81: Grouping Items by Date in a Pivot Table
Figure 81-2: The pivot table, before grouping by months and years.
Figure 81-3: Use the Grouping dialog box to group items in a pivot table.
If you select only Months in the Grouping list box, months in different years are
combined. For example, the June item would display sales for both 2012 and 2013.