Hi all,

My dataset contains a column of start dates / times formatted as

dd/mm/yyyy hh:mm

I have created a pivot table with this field as the column headers. I would like to group all the data by Month and year so that my column headers would read:

Jun 05 Jul 05 Aug 05

and then the data beneath these headings would be the total occurances in the month.

I have done grouping in pivottables before but not with dates and I keep getting an error box saying "Cannot group selection".

I am getting and trying to find out what the problem is cos I know that this can be done.

Any help would be appreciated.

Regards