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.
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.
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks