Chapter 30: Analyzing Data with PivotTables
3030
FIGURE 30.6
The PivotTable with Excel’s automatic grouping
FIGURE 30.7
Use the Grouping dialog box to group PivotTable items by dates.
In the By list box, select only Months and Years and deselect any other groupings Excel may
have automatically created (such as Quarters). Verify that the starting and ending dates are
correct for your data. Click OK. The Date items in the PivotTable are grouped by years and
by months, as shown in Figure 30.8.