Pivot Table grouping and filtering issue

[delboy2405]

Hi,

using Excel 2007 I have a pivot table that counts that number of incidents based on month and year. To get the month and year I group the date field as months and years.

My problem is if I want to filter specfic months in say year 2012 it also takes out the month in 2013. I though it used to give you the option of year and date in the filter but mines are 2 seperate filters

Anyone come across this before?

I am at work and unable to upload the document

 

[Andrew Poulsom]

Can't you use Date Filters with Between?

 

[delboy2405]

Can't you use Date Filters with Between?

Hi, I had tried that but it wasn't working but I have solved the issue now. I think it was using some an old pivot table cache. I deleted the sheet and started again and now works.

Thanks for response though