Unique Filter Options

[Gabe_Miller]

Hello, I am needing to create a filter for a dimension with multiple options as described below:

field:
a,
ab,
abc,
abcd,
b,
bc,
bcd

How do I create a filter to show:
a
b
c
d

So selecting option 'b' would bring up all values that include b?

[Taoufiq_Zarra]

@Gabe_Miller 

In Script you can do for example :

Data:

Load
       field,
       mid(field,IterNo(),1) as UniqueField
While iterno()<=Len(field);

load * inline [
field
a
ab
abc
abcd
b
bc
bcd
]

output: