The Date field is grouped by Month, by right-clicking on a date value and selecting “Group”.
Steps
Notes
Pivot table sum by month
To build a pivot table to summarize data by month, you can use the date grouping feature. In the example shown, the pivot table is uses the Date field to automatically group sales data by month.
