Add A Month Field to Pivot Table

[Tod Lay]

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?

[#2 · Accepted solution]

@Tod Lay 

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.

[#3]

@Hans Vogelaar Perfect answer. Thank you.