Hello Excel Community :)

I have a problem I've been working on for about 4 hours a night for this past entire week and I can't figure it out. I would greatly appreciate any help that will lead me in the right direction to getting this solved so I can go back to sleeping.

The situation:
I have two pivot tables that pull data from two sheets in the workbook.

- The first pivot table "A" shows an average of the persons closed cases per day for each person.
- The second pivot table "B" shows the amount of hours the person worked each day.

The information in sheet 2 for pivot table "A" has a list of all the cases each person closed that day and the chart is set to count the total for the day and display it.

The information for pivot table "B" has a list of all the punch "in/out" times and displays the sum of those duration.

What I am trying to do is have a pivot table or a very low maintenance chart that will take the total cases closed for the person that day and divide it by the hours they worked and show their "average" for that day. I have tried to find a way to use the data from those pivot tables and the only way I have found was to manually add each persons data off the pivot tables to the manual chart. This is not an option as there is too much to track like this manually.

I also tried creating a pivot table using the information from the two sheets that provide the data for pivot table "A" & "B" however when I do that you loose all the unique field labels at the top in the data sheets and only have about 4 options to sort and work with on the pivot table bar. If I could get all the different options on the right to come up with it pulling from one sheet when I set it up for two I could probably make it work. Then it would just be a matter of listing both totals next to each other and doing a calculated field to divide the one by the other.

Again I greatly appreciate help from anybody that can help restore my sanity! :P

- Mau5