Microsoft Office Tutorials and References
In Depth Information
Grouping Pivot Table Items
Figure 18-24: The pivot table, before grouping by month.
Figure 18-25: Use the Grouping dialog box to group pivot table items by dates.
In the By list box, select Months and Years and verify that the starting and ending dates are
correct. Click OK. The Date items in the pivot table are grouped by years and by months, as shown
in Figure 18-26.