C
carl
I have 2 Tables:
Table 1 has my list of products in rows and list of
SalesPeople in Columns. The table identifies (cell entry =
1) which Salespeople are assigned to each product.
Table 2 has my list of products in rows and the Salepeople
that have sold any of the products in Columns. The table
identifies how much each salesperson sold of each product.
Table1
Symbol Group BOX050 BOX060
AIG A0
TWX A1 1 1
ABT A2 1
ALL A3 1
AXP A4 1 1
Table2
FirmId BOX050 BOX060
AIG A0
TWX A1 12
ABT A2 12
ALL A3 12
AXP A4 12 12
I would like to create a table that would tell me IF the
Salesperson is Assigned to the Product, IF the Sold any.
If the answer is yes, return OK. If the answer is no,
return CHECK.
Perhaps the 3rd table would look like this...
FirmId BOX050 BOX060
AIG A0 OK OK
TWX A1 OK CHECK
ABT A2 OK OK
ALL A3 CHECK CHECK
AXP A4 OK OK
Thank you in advance.
Table 1 has my list of products in rows and list of
SalesPeople in Columns. The table identifies (cell entry =
1) which Salespeople are assigned to each product.
Table 2 has my list of products in rows and the Salepeople
that have sold any of the products in Columns. The table
identifies how much each salesperson sold of each product.
Table1
Symbol Group BOX050 BOX060
AIG A0
TWX A1 1 1
ABT A2 1
ALL A3 1
AXP A4 1 1
Table2
FirmId BOX050 BOX060
AIG A0
TWX A1 12
ABT A2 12
ALL A3 12
AXP A4 12 12
I would like to create a table that would tell me IF the
Salesperson is Assigned to the Product, IF the Sold any.
If the answer is yes, return OK. If the answer is no,
return CHECK.
Perhaps the 3rd table would look like this...
FirmId BOX050 BOX060
AIG A0 OK OK
TWX A1 OK CHECK
ABT A2 OK OK
ALL A3 CHECK CHECK
AXP A4 OK OK
Thank you in advance.