M
Michel Khennafi
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
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