1 Reply Latest reply on Sep 23, 2016 6:24 AM by ra.sae.0

    Top scrap value

    Vasudevan S

      Hi,

       

      I am having a scrap data XL like below,

       

      MachinePartQty
      Ametal10
      Aal5
      Abar8
      Aag1
      Bss26
      Bcu1
      Bzn10
      Bni2

      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,

       

      PartValue
      zn50
      ni100
      al20
      cu25
      bar15
      ag50
      ss10
      metal5

       

      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 .