Forum Discussion
Solved
Display multiple fields that reference 1 master table
I have 2 tables Customer Table Company Sales Mgr Acc Mgr Support Mgr Comp A 1 4 4 Comp B 2 3 3 Comp C 1 4 3 Staff Table ID Name 1 James H 2 Tan KK 3...
Thanks. Unpivot does the trick !
hello gancw1
i think it is possible with a little tweak.
1. unpivot your 'Customer' Table.
2. create a relationship many-to-many between 'Customer' table and 'Staff' table.
3. plot in matrix visual with Values taken from 'Name' column in 'Staff' table
Hope this will help.
Thank you.
Thanks. Unpivot does the trick !