Right click on the date field in you Pivot Table, select Group and Show
Detail then select Group and click on Months (and maybe Years) and then hit
OK.

Hope this helps
Rowan

"Rebel" wrote in
message ...

I am trying to organise my pivot table into monthly transactions but I
only have a list of individual dates. Does anyone know how to sort the
date fields?
Thanks.


--
Rebel
------------------------------------------------------------------------
Rebel's Profile:
http://www.excelforum.com/member.php...o&userid=30255
View this thread: http://www.excelforum.com/showthread...hreadid=499246