Forum Discussion

schoden's avatar
schoden
Post Partisan
5 years ago
Solved

Combining

Hi Community, 

 

I have a table : 

Unique ID with combination of name given to it.

 

I want to filter by unique name , that will show all ID it is given. One ID can  appear  twice in the name allocated to it.

I have attached the file. 

 

 https://netlinkgroup-my.sharepoint.com/:u:/g/personal/schoden_netlinkgroup_com_au/EWqOXLftsMhFq7iMOdUcDcEBzIcIgSh73r5iVPcuO7fyhg?e=lWdQCp

 

 

For instance :

"a " is present in ID 1, 3, 4, 6, 7, 9, 10 

"b" is present in ID 1, 2, 3, 4, 5, 7, 8, 10 

Here ID 10 appears in "a" and "b"

 

When user filters "a", show all ID it belongs to 

When user filters "b", show all ID it belongs to

 

Thanks in advance