Can you post some sample workbook. You can Create with some dummy data.
See attached workbook containing dummy data. The "Categories" are the combination of tags for each question. I parsed these out to list as single values under the "Tag" column. The "ID/Rev" is the question item.
Book1.twbx 50.6 KB
Could you upload a 10.3 version or an excel file to use?
Without being able to see if this fits your dataset, I created a vertical table of Question | Tag.
The filter I made:
And then the key is to right click the Tags filter and Add To Context so only the ones selected matter.
As you can see, only Question 4 is a match here and would be the only one to show up once this calculated field was added to the Filters.
Wow, thank you! That did the trick. I've never used the "add to context" feature before and couldn't find any information on it that made sense to me. I'll remember to use this, in addition to creating a calculated field that incorporates the Fixed function. Thank you for making my day!!!
Huzzah! Glad it worked.
It can be a very useful feature when using LOD expressions that need to take that into consideration.
Best of luck the rest of the way!