Filtering one table visual by the attributes of selection in another
I'm trying to develop an app that will match job roles with specs. In one table visual, I have a list of available roles. In another, I have a list of people who could fill those roles.
The underlying tables have columns for attributes, for example - has a driving licence, can work weekends, etc. I want to be able to select the job role in one table and have it filter the candidates table to show the candidates who meet the criteria of the role.
To put it another way, I want to use the first selection as a lookup for the filter parameters on the second table.