Results 1 to 3 of 3

PowerPivot Relationship Problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-30-2008
    Location
    London
    Posts
    127

    PowerPivot Relationship Problem

    Dear all,

    I have excel file (Sheet1)like...
    EmpId Name
    1 Vinay
    2 Ben
    3 Ian
    4 Chris
    5 Rob

    and sheet2 like...
    EmpId SL
    1 120
    3 450
    4 520

    now I want to use powerpivot and want something like..
    EmpId Name SL
    1 Vinay 120
    2 Ben 0
    3 Ian 450
    4 Chris 520
    5 Rob 0

    I have done relationship but it doesnot give me correct answer.

    Please see attached file. I am using Excel 2010.

    Please help!!

    Vinay
    Attached Files Attached Files

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. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  3. PowerPivot Relationship Confusion In Excel 2013
    By tomhouy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2014, 03:26 AM
  4. PowerPivot many to many date relationship
    By chaserracer83 in forum Excel General
    Replies: 1
    Last Post: 10-08-2012, 03:48 PM
  5. Getting problem with Many to Many relationship.
    By Reema in forum Access Tables & Databases
    Replies: 1
    Last Post: 06-03-2009, 01:12 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1