Hello I have the following issue and wonder if you know how to resolve it
Comparing data
I have two tables one is data that shows tasks completed day time and the amount of time to do the task and by whom. The other is a weekly time sheet for each person. I have created two pivot tables that summaries firstly jobs completed and amount of time taken for each job by whom. I have another pivot table that summarises each employee's amount of time worked by week/month/quarter. I wish to compare each workers timesheet to the amount of time that is being recorded for each task. Is this possible using a pivot table?
Thanks
Shawn
Comparing data
I have two tables one is data that shows tasks completed day time and the amount of time to do the task and by whom. The other is a weekly time sheet for each person. I have created two pivot tables that summaries firstly jobs completed and amount of time taken for each job by whom. I have another pivot table that summarises each employee's amount of time worked by week/month/quarter. I wish to compare each workers timesheet to the amount of time that is being recorded for each task. Is this possible using a pivot table?
Thanks
Shawn
