I have a workbook that is displaying a group of users in a target audience. There are two fields: Function and Job Level that I have concatenated into a field called Function Level.
I created a Multi-select dropdown to filter the data by. However, I was wondering if there is a way to have predefined combinations of choices from the multi-select.
For example, can this be done with another drop down and parameter setting? So if I pick "Option 1" on the other drop down choices 1 4 and 7 are checked off on the Function Level multi-select but if "Option 2" is selected choices 6 8 and 9 are checked off on the multi-select... etc
Is this possible in some form? I only have 4 or 5 different "options" but each of them may tick off different options on the multi-select which has like 100 choices.