software

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 8Basically, 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

Build your pivot table normally, with Dates in the Row area. When completed,
right-click on Dates and choose Group and Show Detailgt;Group... from the
pop-up.

Click on Months, then Ctrl-click on Years. Ok your way out of the dialogs

quot;Michel Khennafiquot; wrote:

gt; Good morning guys
gt;
gt; I have a table with 3 colums
gt;
gt; - First name
gt; - date
gt; - Hours off (number from 1 to 8 to account for vacation)
gt;
gt; I would like to do a pivot table where the dates are grouped by months or
gt; year and sum up the hours. for instance the following table
gt;
gt; Joe 5/5/05 3
gt; joe 12/5/05 8
gt; Mike 1//1/06 8
gt; Joe 1/10/06 8
gt;
gt; Would give the following table
gt; Joe Mike
gt; May 05 3
gt;
gt; December 05 8
gt;
gt; January 06 8 8
gt;
gt;
gt; Basically, regrouping the dates by month or year or by month and year in a
gt; pivot table knowing that the source data is expressed in dates
gt;
gt;
gt;
gt;