Question
How to show only one value in the filter when there are multiple values in one data cell like below.
If we add the [Product] in [Filter] shelf, it will show "AA, BB, CC" in the first line. How can I display "AA", "BB", "CC" in separate lines.
Sample data:
==============
ID Product
1000 AA, BB, CC
1001 DD
1002 EE
1003 FF
==============
Wanted Filter Outcome:
==============
AA
BB
CC
DD
EE
FF
==============