4 Replies Latest reply: Sep 1, 2014 8:25 AM by Sander van Koppen RSS

    Partial Dimension Load

      Dear,

       

      I have 2 tables which I'd like to link. Unfortunatly the 2 tables don't have the same info I can link.

       

      Please see below:

       

      Table1

      Customer     Customerno.

      A                    100010  

      B                    200500

       

      Table 2

      Shipto               Sales

      100010-01          10

      100010-02          20
      100010-03          30

      200500-01          15

      200500-02          20

      200500-03          10

       

       

      For the overview I want to make, I need to link the sales per customer.

       

      Is there a way to load the the first 6 numbers info from Table 2, "shipto" (I have about 500 different customers)

       

       

      I want to have the following in mij Chart:

       

      Customer         Customerno.     Sales

      A                      100010               60

      B                      200500               45

       

       

      thanks in advance.

       

      Best Regards,

      Sander