Pivot Table and Sorting by Month Only

Hi,

I have a pivot table and I want to display results by months only and not by multiple days. I know I can go into date filters and sort by a specific month but what I want is to have the pivot table display by months only without the specific days, with all months showing

In essence, I want an September, October, November etc field without the specif days.

Am I making sense. See attached sample.

Thanks and this site is so helpful.

Hi Peekay,

Ive done it for you, but for the future. Right click and look for Group

Cheers

Any questions pls ask