Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have 5 columns each values are unique vlaues . i have one column DOM Filter . DOM filter have combine value and also seperate value . i have attached sample date for reference
Code Value 1 value 2 value 3 DOM
101 5 10 7 A104
101 5 10 7 B104,S104,A104
101 5 10 7 Z104,R104
101 5 10 7 G104,A104
101 5 10 7 O104
101 5 10 7 R104
101 5 10 7 S104,Z104
I have seperate sheet for DOM filter
DOM Filter
A104
B104
Z104
O104
G104
R104
S104
If i select value A104 in filter value should come from combine value and seperate value . like
VALUE 1 VALUE 2 VALUE 3
A104 15 30 21
any idea ? thanks in advance .
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |