Possible to summarise worked hours in a pivot table?

Topic Labels: Extensions
697 1
Showing results for 
Search instead for 
Did you mean: 

I don’t know if this is possible, as I tried everything and I can’t come up with any solution.

I have a table where I want to compare staff worked hours against ‘expected’ worked hours.
I have two tables A and B
A has the staff names and the weekly expected working hours for each staff.
B logs the staff hours.

Is it possible to summarise the weekly worked hours in a pivot table but where the weekly expected hours has been subtracted to see if staff is working more or less as expected?

1 Reply 1
7 - App Architect
7 - App Architect

As the data is in two tables, it is impossible to compare that data without some kind of Link.

Personally, I would create a table called Days (if you are tracking single days) or Weeks etc., and then link from the Day to table A (relevant records), and also to table B.

Now your new table is pulling a rollup Sum(values) of the Estimate and the Actuals, you can probably fill in the rest (new column, calculate difference, plot as chart…)