issues with relationships

So i am building a report that will showestablishment (number of empoloyees and FTE etc.) for areas in our service.

I have a list of all staff, their areas, position and their FTE on a sheet called Establishment. I am building a sheet, currently called sheet3 that has how many FTE are allocated to each area for each position.

I want to show on the report, when i use a slicer to filter by area or sub team, i want it to show the FTE allocated next to each job role. I currently have it so it does that but it is the Sum of FTE for that job role and not sliced for each area/subteam.

It appears i can only have one active relationship and i think this is what the issue is. I think i need to have active relationships to all the options for the slicers too? if anyone has any idea that would be greatly appreciated.

Below, dashboard giving an idea of what im looking for and the sheet3 headers which match those of establishment (except for names etc.)