How to create a slicer based on multiple string values per row

[sloane]

Hi All, 

I currently have a dataset that looks a bit like the table below, and need to create a slicer that gives the respective amount with the distinct string values in the column Category. 

The expected behavior is that the slicer says HOR; THR; COM; DRA and if I select  THR I get a sum of all amounts with thr (1,200,000) or a count of all categories with THR (3)

Thank you in advance for any help!

[vslaser]

If you transform the data and split the 1st column by "comma" into rows, then you will have the data in rows without commas anymore. The column can then be used as slicer.

Here is a sample:https://drive.google.com/file/d/1d2_hUbEyxu_PtoQjIMPZ7DUbmVFj1ZYd/view?usp=sharing

Regards,

Vijay

[Anonymous · Accepted solution]

@sloane , Please split the column by delimiter this way you will get the separate values. 

The rest will work as expected:

Did I solve your problem? 

Please mark my answer as a solution!