Forum Discussion
matrix
Can you post some example source data that you are trying to transofrm in the end result
Thank you for replying! Sure thing,
The first table is where id represents Products, and each Manufacturer of the specific product has its own numeric id.
The PROD1 Value in my matrix is the Distinct Count of how many Products each Manufacturer produces. (We can see that Manufacturer 1093 produces several items on this chart).
This second table shows the relationship between Manufacturers and their respective Dealers/sellers.
In my matrix, the columns are Dealers, the rows are Manufacturers, and the Values are Count of Products (PROD1) and if a relationship exists between Dealers and Manufacturers (ASSOC1). I want a 0 to show if this relationship exists, but the Dealer has not received any of the manufacturer's items.
What are you using to calculate ASSOC1?
Can you please post it so that I can work of of that
Yes! In the second table I posted, Dealers and Manufacturers are associated to each other by their arbitrary I.D. "key." If a key exists, it simply shows as "1" in the ASSOC1 column (The calculation is Distinct Count of these keys for each respective column-row).