Thanks for your reply.
But I cant have a parameter as i have n number of skills in an organization and they will be updating all the time.
and one more thing in the result set i need only zzz to be display not yyy and zzz.
Thanks for that.
i feel i should mention very clearly here.
The selection can be either just one skill or 2 or 3 or any number of it is. Generally they look for one skill. But they even look for people who have multiple skills like both Tableau and MS BI with project management. In this example i have given 3 skills,
Hope i didn't confuse you.
As it is in the organization so i have lot many people with lot many skills. So i cant have parameter for the skills, like i have 1700 distinct skills in my field and they grow usually and at the same time in this example i really cant fix something like 3 or 2 in the calculation how you mentioned and i too have many selections not only name.
I have people possessed with number of skills like below. so if i fix for 2,3 how it works? Correct me if i am wrong here...
Somehow this idea helped me having with two additional selections. One with a parameter for number of skills and one is for T/F for calculation.
Great it Worked for You!!!
I am looking for one more additional thing here..
There is one more set of data available with people and their skills. They are contractors in my organization. Imagine this is Set B..
So now i want to check the skills from Set B and if those skills matches with my organizational skills, Set A then i want to list them.
Say in Set B, i have a person working on Tableau. But then if i click on that skill (Tableau) or if i look for Tableau from Set B i want to list down the people who are having skills of Tableau from Set A.
Here the skills wont exactly match. say .Net in my Set B but then in Set A they might have mentioned like .Net Developer something like that. So i really cant join or something like that to do. but then bit confused how can i get it..
I have to relate if a skill matches from Set B in Set A and list down the employees who is having that skill from Set A.
Any idea please!!