Hi -

For my project I need to find delta's in hours between ressources. I have created 2 pivot tables - the 1st one is for the estimate hours per week and the 2nd pivot tables is the real hours made per week by each resssources.

I need to find the delta for each ressources by ''matching'' them together by week .. let's say : John X was forecasted 40 hours on the week ending date of July 13th and he made 32 hours in reality. I'm trying to find a way between the 2 pivots tables to ''talk/connect'' to each other so they can matches ressources together.

The plan is to create a ''3rd'' pivot tables including the Forecasted hours, the actuals hours made and the delta between those 2.

I have enclosed a spreadsheet with details for the purpose of my question.

Thanks in advance - for all your assistance.

example.xls