How to structure a filter in a more user friendly way

[ronaldwang]

I have a data with a column in the below structure: have multiple values within each record. I want to give the user the the filter as the second graph: when selecting A, the column with A included in the Tag column should be shown, is there any easy way to achieve this? thanks

[Vegar]

You need a dimension containing these values and that is associated to your Tag field values.

I would handle this  in the script like I try to show below.

Data:

Load [Dimension1], [Dimension2], [Tag], [Amount]

From Source;

TAG:

Load DISTICT [Tag], subfield([Tag], ',') as [Tag Filter]

From Source;

[ronaldwang]

Thanks Vegar, 

And then how I can associate  Tag in Data to Tag in TAG. or how I can link them together, as the value is not the same.E,g A,B in Data table and A in TAG table. thanks

[Vegar · Accepted solution]

In my example I use the [Tag] field as a link between the two tables. It will create the associations you need.

If you select the [Tag Filter] = A using the data in your original post you will get associations with the following Tag values in the Data table.

• A,B,C
• A,B
• D,A,E
• A,B,D