I have a SharePoint list and one of the columns is a Managed Metadata field for users to tag items with one or more tags. The users want a report that will allow them to filter by this keyword column.
So if I have
ID | Title | Keywords
1 | Example 1 | Finance; Tax
2 | Example 2 | Corporate; Planning; Tax
3 | Example 3 | Personal
and I filter by Tax I should get the first two items returned. I have created a calculated column in my report so that the MMD field doesn't appear with the ID number in front of it.
Instead of 15#;Corporate;#21;#Planning;#35;#Tax I have Corporate, Planning, Tax but I cannot figure out how to dynamically populate the parameter without duplicates or how to filter fields with more than one tag. Surely I am missing something here?