I have 4 different dimensions linked to a specific evaluation result. Those are Profile (data architect,data scientist,etc), Seniority(junior,medio,etc),Sector (front end, full stack,etc) ,Individuals(Oliver,Peter,etc).
Each of these for dimension as you can see have multiple values linked to a set of evaluation_result linked for a specific topic (215 topics with a unique id).
On the front end, i want to give the opportunity to select a custom combo of these 4 dimension and compare the result of an employee with the max(evaluation_result).
So to make it clear i need to select the highest value for each topic depending on the selection made by the user considering all dimension are not selected for sure.