Two related fields on the same table but several tables missing both related fields

Hello!

I'm experiencing this issue when arriving at the totals for my report. I currently have several tables that are connected by the same related field (many-to-many) called Employee ID. However, I'm hoping to display the account (many-to-many) totals for each of these employees based on an account ID. At the moment my results are giving me the total Employee ID amounts for each account so for example: 

I'm wondering if this is an data model issue or is there another root cause? I considered merging the Account Revenue Files and Sales Pipeline Files into a new query but thought there might be a better resolution.

Thank you!