3 Replies Latest reply on Jan 20, 2014 6:15 AM by Matt Lutton

    Joined excel tables multiplied the sum

    Emil Schweiger

      Dear Forum,

       

         I have 3 tables in Excel (same file, different worksheet) which are

      now joined by the dimension {Country] which is present in all three.

      The problem is that the data from one of the sheets (amount of

      consumer contact) is multiplied 8 times when I drag it in.

      Also the dimension [Country] doesn't show up in the dimension list

      for that table even though it is used to join the tables.

       

        Any thoughts on this? It is driving me crazy.