Microsoft Office Tutorials and References
In Depth Information
Figure 18-26: 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-27.
If you select only Months from the By list box of the Grouping dialog box, months in dif-
ferent years combine together. For example, the January item would display sales for
both 2012 and 2013.