Date Filter in PivotTable

**pakiyabhai** · 05-27-2010, 04:26 AM

I have a pivot table with a date column containing daily dates for three months , I want to create a filter for a month ,

1. I change the numberformat of date column in excel to 'mmmm' which gave me month's name in excel table

2. But pivot table still reads the data source(after updating) as individual dates , and not months help ?

Column A has
1/1/2010
1/2/2010
1/3/2010
1/4/2010

After giving number format to mmmm , it becomes

Column A
Jan
Jan
Jan
Jan ,

But Pivot Table still reads it as
Column A
1/1/2010
1/2/2010

I hope I am clear

**Ryan Murtagh** · 05-27-2010, 04:35 AM

Right click on the date field in your PivotTable and select Field Settings. Click the Number Format button at the bottom of the dialog box and set your custom formatting there.

**pakiyabhai** · 05-27-2010, 04:53 AM

Thanx for the reply ,Ryan , I had like to setup date as a filter, I m able to achieve this if I set up dates in row or values , but not in filter,

**Ryan Murtagh** · 05-27-2010, 05:02 AM

1. Start by putting the date in the row field
2. Right click and select Group
3. Choose how you would like to group the data (in this case, month)
4. Move the date to the Report Filter field