I think you can get the final output using blending.
However, you might have to create an extract from the table 2 which will remove product id column. Use blending where the join will be created on the basis of name.
Thanks. I can get the numbers by blending for individuals. However not sure for managers, how do I get it? Since (for example : Kerry's numbers would include his self, Loius and Jim). Now Louis's number would be his self and Lee. So there is a hierarchy here, how do compute it?