Converting daily data into weekly
 

I have a sheet of data pulled from Remedy (40,000 rows, 3 columns). Each
record is created with date and time, user group and user. I created a pivot
table to get a total count of records assigned to each individual, however, I
would like to break it down even further, by doing a weekly count of records
assigned to the individual. I removed the time from the field and left with
the day, such as Jan 1, Jan 2.

Is there someway to convert the day field and combine them into weekly
groups to pull a total count by individual, per week, starting Jan. 1 to
present day?

Converting daily data into weekly
 

Once the table is setup, drag the dates to the row field and the individuals
once to the data field and once to the row field (you can of course drag it
to the column but that will make the table very broad I assume), click
finish. Then right click somewhere in the date dates and select group, then
group by days only (clear months) and below you can select number of days
using the little spin button, select 7. In the same dialogue box you can set
start and end date. Then click OK.


--


Regards,


Peo Sjoblom



"Robin" wrote in message
...
I have a sheet of data pulled from Remedy (40,000 rows, 3 columns). Each
record is created with date and time, user group and user. I created a
pivot
table to get a total count of records assigned to each individual,
however, I
would like to break it down even further, by doing a weekly count of
records
assigned to the individual. I removed the time from the field and left
with
the day, such as Jan 1, Jan 2.

Is there someway to convert the day field and combine them into weekly
groups to pull a total count by individual, per week, starting Jan. 1 to
present day?