Chapter 30: Analyzing Data with PivotTables
3030
FIGURE 30.4
PivotTables with options for subtotals and grand totals
Automatic grouping examples
When a field contains numbers, dates, or times, Excel can create groups automatically. The
two examples in this section demonstrate automatic grouping.
Grouping by date
Figure 30.5 shows a portion of a simple table with two fields: Date and Sales. This table has
731 rows and covers the dates between January 1, 2019, and December 31, 2020. The goal is
to summarize the sales information by month.