Comparing data in pivot tables

shawn_c

New Member
Joined
Apr 5, 2011
Messages
1
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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top