Part IV: Managing and Analyzing Data
FIGURE 30.8
The PivotTable, after grouping by month and yearIf you select only Months in the By list box in the Grouping dialog box, months in different years combine. For exam-
ple, the January item would display the sum of sales for 2019 and 2020.Figure 30.9 shows another view of the data, grouped by quarter and by year.