I am having a scrap data XL like below,
From this i found out the top 3 scrap parts using tableau & made a chart.
I am having seperate sheet for value of each part like below,
Now i want to find out the "value" for each part from to table 2 and multiply it in "Qty" and find out the top 2 scrap part in terms of value .
I guess both data are on different sheets / Excel.
Please use the Join feature of Tableau to join them. or Data blending to them. The below link would be handy.
Please let us know if you are facing any issues.