+ Reply to Thread
Results 1 to 1 of 1

PowerPivot lookup table to create link between tables

  1. 10-09-2018, 01:02 PM #1
    Harveyhirst1
    Harveyhirst1 is offline
    Registered User
    Join Date
    01-22-2018
    Location
    West Yorkshire, England
    MS-Off Ver
    2016
    Posts
    8

    PowerPivot lookup table to create link between tables

    Hello,

    I am trying to use a table to relate two tables of data.

    Simple.png

    The middle table should confirm a relationship between the two tables.

    Shouldn't this be enough to create the below pivot table?

    Desired Pivot.png

    I have created relationships in PowerPivot (file attached) is there something i am missing?

    Thanks in advance,

    Harvey
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel powerpivot - create relationship between 2 excel tables files located in my des
    By Kriman in forum Excel General
    Replies: 1
    Last Post: 03-05-2020, 11:37 AM
  2. Row to column table? How to link two tables?
    By behedwin in forum Excel General
    Replies: 3
    Last Post: 06-09-2017, 09:38 AM
  3. Can I create the same relationship on multiple tables at once in PowerPivot?
    By missinglina in forum Excel General
    Replies: 0
    Last Post: 07-08-2016, 12:20 PM
  4. Table vs. Lookup table in Powerpivot
    By stephme55 in forum Excel General
    Replies: 2
    Last Post: 07-07-2016, 02:24 PM
  5. [SOLVED] Excel pivot table tied to POWERPIVOT won't refresh without opening POWERPIVOT?
    By Rhino_dance in forum Excel General
    Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  6. Create relation between 2 PowerPivot tables - not working - why?
    By oleisbest in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 09-04-2014, 10:16 AM
  7. PowerPivot - Sort by column working in Powerpivot, but not actual pivot table
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-02-2014, 09:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1