Microsoft Office Tutorials and References
In Depth Information
Figure 18-24: You can use a pivot table to summarize the sales data by month.
A workbook demonstrating how to group pivot table items by date is available at this
book's website. The file is named sales by date.xlsx.
Figure 18-25 shows part of a pivot table created from the data. The Date field is in the Row Labels section, and
the Sales field is in the Values section. Not surprisingly, the pivot table looks exactly like the input data because
the dates have not been grouped.
To group the items by month, select any date and choose PivotTable Tools ⇒ Analyze ⇒ Group ⇒ Group Field (or,
right-click and choose Group from the shortcut menu). You see the Grouping dialog box in Figure 18-26.