Two different field values in one field

[#1]

Hello all,

I need help in below requirement.I have a field Manager from Table-1 and Employee from Table-2 .Now i need a new field Customer where it should have all the values of Manger and Employee.

When i select a value in Customer, all the associated values in both Manager and Employee should show up.

Ex: Manager            Employee

       AAA                    CCC

       BBB                    XXX

       CCC                    DDD

        AAA                    AAA

       DDD                    BBB

        AAA                   YYY

        ZZZ                    AAA

Now when i select AAA in Customer field i need the result as below

        Manager              Employee

      AAA                       CCC

      AAA                        AAA

      AAA                       YYY

      ZZZ                        AAA

Thanks in Advance.

[aarkay29]

PFA

[#3]

Thanks Aar Kay for the quick response.

In my real data, Manager and Employee fields comes from two different tables .Manager is in Dimension table where as Employee in fact table.So when i select a value in customer field associated measures  from fact table should also reflect.

Hope i am clear with my requirement.

[aarkay29]

Can you please post sample data to replicate you model so that I can give you the exact solution

or screenshot of your datamodel to get an idea.

[#5]

PFA

[aarkay29]

May be this

DirectCustomers:

Load

%Customer_Account_ID,

[Customer Name]  as Direct_Customer

Resident

              Customers;

Concatenate(DirectCustomers)

Load

%Customer_Account_ID,

[Referral Customer Name]  as Direct_Customer

Resident

              Orders;