Pivot Tables

R

Rebel

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.
 
R

Rowan Drummond

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
 
Top