Creating a Matrix with a secondary relationship between tables

Hi everyone,
I have 3 tables, Fin_data_by_month (fields: Month, total revenue, engagement division), revenue_targets (fields: month, engagement divison, monthly target) and one date table. I have created a relationship between the date table and the other 2 tables at a date level (image below).

I want to create a matrix with date and engaement division as rows and total revenue and monthly targets as values. Date looks good but when I use engagement divison field from the fin_data table, total revenue looks good and monthly targets are aggregated for all divisons(image below) and when I use engagement division from the targets table targets look good and total revenue is aggregated. I want to create a matrix like this but with the correct values. 

I am unable to create a relationship between fin_data and targets tables at an engagement division level. I get the below error. 

Here's a test file I've created. Any help is appreciated. Thank you so much! Greg_Deckler  amitchandak Ashish_Mathur 
https://drive.google.com/file/d/1jERpHceHGHwI0q74TUnxWLEyM7aPY8Tc/view?usp=sharing