Then, change the Month formula to:

=DATE(YEAR(F1),MONTH(F1),1)

In the pivot table, format the Month field (FormatCells, Number tab) to
the custom format of mmm yy



Randy Harris wrote:
I've been trying that. It won't let me group the data - "Because the field
is grouped, you cannot add a calculated item to it.". I've repeatedly
ungrouped, but still get that message.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html