9 Replies Latest reply: Oct 24, 2013 5:37 AM by Nayan Lalla RSS

    Linking Tables

    Nayan Lalla

      Hi

       

      I want to link tables , where the values are are in columns with different names.   Let me elaborate the issue im sitting with:

       

      I have a Item, BPHDMI,  which is made up of 3 components as shown in table below callled Bill of Materials.  One of each of the component is needed to make BPHDMI.

       

       

      Bill of Materials

       

      Item CodeComponent CodeComponent Qty
      BPHDMIZZBPHDMI1
      BPHDMIES1
      BPHDMIICHDMI1

       

      In the next table below , I have the cost of each component as well as the cost of the final product.

      In this table , the component as well as the final product is under the column "Item Code".  Whereas above the Components are Item are in seperate columns.

       

      Warehouse

       

      Item CodeUnit cost
      BPHDMI500.00
      ZZBPHDMI300.00
      ES150.00
      ICHDMI50.00

       

      What i am trying to create is a straight table or pivot table showing sum the costs of  components to be the total value of the final product.  ( as below) .

       

      Item CodeComponent CodeUnit Cost
      BPHDMIZZBPHDMI300.00
      ES150.00
      ICHDMI50.00
      Total 500.00

       

      How do i do this.  Please help.  Thanks.

       

      I have attached an excel spreadsheet.  I also included a second item.

       

      kind regards

      Nayan