Forum Discussion
Solved
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?
I've entered the following formula in your cell F2 and copied it to H2 and L2,
=FILTER($A$2:$B$13,$C$2:$C$13=F1,"None")
The result is this
Go check it out
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.
HansVogelaar Perfect answer. Thank you.
