+ Reply to Thread
Results 1 to 2 of 2

Create relation between 2 PowerPivot tables - not working - why?

  1. #1
    Registered User
    Join Date
    Oslo, Norway
    MS-Off Ver
    Excel 2003

    Question Create relation between 2 PowerPivot tables - not working - why?


    I have two tables in PowerPivot that I'm trying to connect.
    • Table 1 contains information about several contracts (but does not contain information on the value of the contracts)
    • Table two contains value on the different contracts

    As i don't have a unique ID in either of the tables I have created a new calculated column in both tables. Both calculated fields is formatted as text as it is a combination of a contract number and a description of the rented area. In table 1 this is not an unique value. In table 2 this is an unique value.

    The ID look like this: 15432_Officspace

    The relation is between table 1 (does not contain a unique ID) and table 2 (contains a unique ID).

    With this relation I thought I could get all contracts from table 1 and match these together with rent from table 2. This however does not work.

    The tables look like this:


    When creating a PowerPivot in Excel I choose the different columns from table 1 I need information about and then go to table 2 and choose the column containing the rental value. When doing this I get the same rental value for all contracts, the sum of all rent, and i get prompted that i may have to create a new new realionship. What am I not getting?

    Hope someone can help me

    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Create relation between 2 PowerPivot tables - not working - why?

    Ole, you may want to import the data from table 2 to table 1 using the RELATED function and then add that column (in table 1) to your pivot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-05-2020, 11:37 AM
  2. [SOLVED] Relation of 2 Tables
    By PFGF in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-03-2014, 12:10 PM
  3. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  4. linking tables with access-style relation in excel
    By stephenjosephmurphy in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 09:19 PM
  5. PowerPivot Tables
    By amotto11 in forum Excel General
    Replies: 9
    Last Post: 08-23-2011, 05:53 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1