Part V: Analyzing Data with Excel
720
FIGURE 35.6The pivot table, before grouping by month.
FIGURE 35.7Use 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
for your data. Click OK. The Date items in the pivot table are grouped by years and by months, as
shown in Figure 35.8.Note
If you select only Months in the By list box in the Grouping dialog box, months in different years combine
together. For example, the January item would display sales for both 2008 and 2009. n