Scan different fields value and compare based on User selection
Hello,
I tried to look for this question in different threads and couldn't find the answer. maybe someone here can help
Basically, I have 6 columns table with different values inside that can repeat in all of the columns,
I want to give the user the option to select a combination of columns, then present only the lines where the cells values in those columns are match to each other.
for example:
Customer1
Customer2
Customer3
Customer4
Customer5
Customer6
B
A
B
B
V
B
C
A
V
B
B
B
A
V
A
B
B
V
A
C
C
A
C
A
A
B
B
C
C
C
The user can select which customer he wants to compare -
If the user select Customer1+Customer4+Customer6 the only lines that will appear are lines 1 and 4 (marked as red).
I've tried to work with variables that gets populate with the Column name based on the selection, then creating calculated dimension that compare the values, but it's too complicated (there are more than 60 permutations), and the performance in case of many lines is poor.