There are 2 columns with multiple tests mapped to multiple packages.
I select distinct values of multiple tests in a combo box and want to select a package which consists of these multiple tests.
For distinct tests-
Sort(Distinct(Table1,Tests),Result)
For relevant packages-
Distinct(Filter(Table1,Tests in ComboBox1.SelectedItems.Result),Package)
But, the 2nd result gives me the package for last selection(not combination of multiple sleections in combo box)
How can i slelect a combination of all tests from 1st combo box and then select a package with all those tests.
FYI- Every package consists of 15-20 tests arranged in random order
Data is arranged as-
| Package 1 | Test 1 |
| Package 1 | Test 3 |
| Package 1 | Test 10 |
| Package 1 | Test 20 |
| Package 1 | Test 29 |
| Package 1 | Test 7 |
| Package 1 | Test 23 |
| Package 1 | Test 90 |
| Package 1 | Test 27 |
| Package 2 | Test 10 |
| Package 3 | Test 20 |
| Package 4 | Test 29 |
| Package 5 | Test 7 |
| Package 6 | Test 23 |
| Package 7 | Test 90 |
| Package 8 | Test 27 |
