I have a table were the last column can contain multiple comma separated values. See column C in the data table below as an example.
[TABLE="class: cms_table, width: 251"]
<tbody>[TR]
[TD][/TD]
[TD]Column A [/TD]
[TD]Column B [/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jimi[/TD]
[TD]jimi@email.com[/TD]
[TD]Vocals, Guitar[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mitch[/TD]
[TD]mitch@email.com[/TD]
[TD]Drums[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Noel[/TD]
[TD]noel@email.com[/TD]
[TD]Vocals, Bass, Guitar[/TD]
[/TR]
</tbody>[/TABLE]
A user would like to filter Column C by unique value e.g. "Guitar", or "Vocals" to return all the rows which have that values. Rather than using an Advanced Filter, is there a way to set up a slicer or use slicer style buttons marked "Guitar" "Drums" "Vocals" "Bass", which when selected would return the rows with those values?
For example:
Thanks!
[TABLE="class: cms_table, width: 251"]
<tbody>[TR]
[TD][/TD]
[TD]Column A [/TD]
[TD]Column B [/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jimi[/TD]
[TD]jimi@email.com[/TD]
[TD]Vocals, Guitar[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Mitch[/TD]
[TD]mitch@email.com[/TD]
[TD]Drums[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Noel[/TD]
[TD]noel@email.com[/TD]
[TD]Vocals, Bass, Guitar[/TD]
[/TR]
</tbody>[/TABLE]
A user would like to filter Column C by unique value e.g. "Guitar", or "Vocals" to return all the rows which have that values. Rather than using an Advanced Filter, is there a way to set up a slicer or use slicer style buttons marked "Guitar" "Drums" "Vocals" "Bass", which when selected would return the rows with those values?
For example:
- If I clicked on the button marked Guitar, it would show rows 1 & 3, but filter out row 2.
- If I clicked on the button marked Drums, it would only show row 2.
Thanks!