1 of 1 people found this helpful
Welcome to the Forum.
Though your question seems similar to this one:
there may be some differences with your setup.
In the example in the link, rather than union or join, the two sources were blended:
your specific example is given as a scenario for when one might want to blend.
After the blending on SalesPerson and Product, the Close Ratio was calculated as:
showing that the Quotes Sum came from the other sheet.
It looked like the above screenshots were of fake data.
If so, would be grateful if you would post that file,
or a workbook connected to that file.