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?