1. Assume we have 4 customers (A, B, C & D) and each customer has its own fields and logics as mentioned below.
Customer Field Logic
A AB A11
A AC B12
A AD D34
B AC J76
B AE E90
B AD F34
B AO I87
C AB G23
C CD K45
D BO A17
D AC C09
D CD V89
Now, if a customer is selected (assume Customer A is selected). I need the below mentioned things.
1. Total Number of fields for the selected customer (3).
2. Reusable fields count matching exactly same with the other customers (excluding selected customer) ,
(2 fields of A exactly matches with fields of B, similarly 1 field matches with C and D).
3. Here is the critical part - Assume if we select the reusable fields count (2 matching fields from customer B), I want totally 3 fields in a table as shown below (since 3 is the total no. of fields of customer A).
AB A11 -- Not matched
AC J76 -- Matched
AD F34 -- Matched
In the above table, Field AB from customer A is not used in customer B. So the logic should be A's logic (A11).
But the other fields AC and AD from customer A are used in customer B. So the logic should be B's logic (J76 and F34).
Note: The fields are same, only difference is Logic.
This is where my problem if we multi-select reusable fields of both B and C (from point 3) - I need to show both matching and unmatching fields. This is why I'm looking for a dynamic expression.