Forum Discussion
Add A Month Field to Pivot Table
I have table of data that includes the date. I want that to be in the row of my pivot table. However, the user will want to filter on month. and see data for each day of that month. I assume I need to create a filter field using the Date, but how?
First, move the date field to the Rows area.
Right-click any of the dates in the pivot table.
Select Group... from the context menu.
In the Grouping dialog, select Years, Months and Days.
Click OK.
This will add Years and Months to the Rows area.
Drag Years to the Filters area, then drag Months to the Filters area.
The user can then filter by year and by month.
2 Replies
First, move the date field to the Rows area.
Right-click any of the dates in the pivot table.
Select Group... from the context menu.
In the Grouping dialog, select Years, Months and Days.
Click OK.
This will add Years and Months to the Rows area.
Drag Years to the Filters area, then drag Months to the Filters area.
The user can then filter by year and by month.
- Tod LayCopper Contributor
HansVogelaar Perfect answer. Thank you.