Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table
Good morning guys
I have a table with 3 colums - First name - date - Hours off (number from 1 to 8 to account for vacation) I would like to do a pivot table where the dates are grouped by months or year and sum up the hours. for instance the following table Joe 5/5/05 3 joe 12/5/05 8 Mike 1//1/06 8 Joe 1/10/06 8 Would give the following table Joe Mike May 05 3 December 05 8 January 06 8 8 Basically, regrouping the dates by month or year or by month and year in a pivot table knowing that the source data is expressed in dates |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table
Build your pivot table normally, with Dates in the Row area. When completed,
right-click on Dates and choose Group and Show DetailGroup... from the pop-up. Click on Months, then Ctrl-click on Years. Ok your way out of the dialogs "Michel Khennafi" wrote: Good morning guys I have a table with 3 colums - First name - date - Hours off (number from 1 to 8 to account for vacation) I would like to do a pivot table where the dates are grouped by months or year and sum up the hours. for instance the following table Joe 5/5/05 3 joe 12/5/05 8 Mike 1//1/06 8 Joe 1/10/06 8 Would give the following table Joe Mike May 05 3 December 05 8 January 06 8 8 Basically, regrouping the dates by month or year or by month and year in a pivot table knowing that the source data is expressed in dates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions |