| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
I have a set of data in columns with an entry for a date in each row. I would like to use a pivot table to calculate the totals in the rows by month as oppose to by day. How do I roll up a dd/mm/yy format to subtotal the months? Regards Filky -- filky ------------------------------------------------------------------------ filky's Profile: http://www.excelforum.com/member.php...o&userid=11801 View this thread: http://www.excelforum.com/showthread...hreadid=492601 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
Right click on the date field in your pivot table. Select Group and Show
Detail and then Group. Click on Months (and maybe Tears) and then OK. Hope this helps Rowan filky wrote: I have a set of data in columns with an entry for a date in each row. I would like to use a pivot table to calculate the totals in the rows by month as oppose to by day. How do I roll up a dd/mm/yy format to subtotal the months? Regards Filky |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
Of course that should read:
Click on Months (and maybe Years)... Regards Rowan Rowan Drummond wrote: Right click on the date field in your pivot table. Select Group and Show Detail and then Group. Click on Months (and maybe Tears) and then OK. Hope this helps Rowan filky wrote: I have a set of data in columns with an entry for a date in each row. I would like to use a pivot table to calculate the totals in the rows by month as oppose to by day. How do I roll up a dd/mm/yy format to subtotal the months? Regards Filky |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
Thanks Rowan - very obvious yet incredibly helpful when you don't know..! -- filky ------------------------------------------------------------------------ filky's Profile: http://www.excelforum.com/member.php...o&userid=11801 View this thread: http://www.excelforum.com/showthread...hreadid=492601 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Tables
You're welcome.
filky wrote: Thanks Rowan - very obvious yet incredibly helpful when you don't know..! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
| Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Hybrid Mode
