Create a new field called year, by adding a calculated field to your
existing data as follows:-

=Year(Cell containing date)

Then add this new field to your pivot table as a column (before the
date), now when dates are grouped they will be forced into years and
months, by the two fields within the columns.

If you don't have a format for mmm-yyyy, select custom format and type
in mmm-yyyy as the format code. This format won't work, if you have
grouped data into months on the pivot table


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=542428