Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |