Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to write a report that will tell us if vendors are set up in the proper companies. I'm playing with a matrix, but the matrix will not show the column if there is no data to support it. Here are the 3 tables I'm working with and an example:
Company table: main financial table listing all available companies
vendor table 1: vendor table with no company name (vendor master)
vendor table 2: each row has the vendor name and the company they are set up for. In this example, there would be two rows in that table (financial system company vendor master)
Any help or guidance is greatly appreciated.
Vendor | Company A | Company B | Company C |
Acme | Yes | No | Yes |
Solved! Go to Solution.
That worked great, Marcus! Thanks!
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |