Filtering and Relationships with two variables for a product

[dxg169]

Hi, I'm having issues with filtering on three tables I have.

I have an instance where a number of deals have more than one sub-sector allocated to it. However I want to have a matrix which has the sub-sector, then ANY deal in that sub-sector and the associated costs. Currently my output shows the correct deals, but the sub-total of cost is incorrect.

See screenshots below.

Any help will be greatly appreciated.

Table: Cashflow per deal

Table: Sub-sector mapping

Table: Deal list (unique value per deal)

Mapping

Current output. The deal codes shown are correct, but the sub-totals for each sub-sector are the same and a total of all deals.

[amitchandak · Accepted solution]

@dxg169 , Create a  many to many on join between cash flow and sub-sector and delete the deal join, That might work better