Create a Set Analysis based on dimensions’ key properties

[GuillaumeCharriere]

Hello everyone !  

I need your help and advice. I would like to create a graph that displays the base salary of all employees having the same key properties as the employee selected in the filter: 

Emp Num	Region	Business Line	Job Level	Job Family	Base Salary
2345	North Amercia	Asset Management	2	Sales	45,000
2322	North Amercia	Asset management	2	Sales	43,500
8736	Southern europe	Services	4	Sales	73,000
5673	Southern Europe	Support	3	HR	55,000
2376	North America	Support	2	HR	37,000
2389	North America	Asset Management	3	Sales	53,000
2329	North America	Asset Management	2	Sales	31,000

For example, if the user enters the Emp Numb 2345, the bar chart will display the average base salary for employees 2345+2322+2329, to be able to compare his position with the market average 

Is there a way for a set analysis to modify the results of the Base Salary taking into account the key properties of the employee selected ? 

Thanks for your help !

[sunny_talwar]

Create an island table with a single value? and use that as your dimension