+ Reply to Thread
Results 1 to 5 of 5

PowerPivot/PivotTable showing same results after relationship building.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    104

    PowerPivot/PivotTable showing same results after relationship building.

    Hello friends, hope all is well!

    Please help me with the powerpivot/pivottable here. I have an external workbook with 3 sheets.
    17nam and 18nam have non-duplicated patient-names. I want to link the sheet “17-18” to both “17nam” and “18nam”.

    The images here show that I built a relationship between all 3 sheets, but the outcome in the table shows the SAME numbers.
    Please help me display the actual different numbers.

    Thank you very much in advance
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: PowerPivot/PivotTable showing same results after relationship building.

    Hard to say without sample, but it looks as though you had built ambiguous relationship.

    You should append 18nam to 17nam to create single dimension table for staff and then built your relationship off of that table.

    To get further help, I'd recommend uploading desensitized sample file.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    104

    Re: PowerPivot/PivotTable showing same results after relationship building.

    Thank you very much for replying. I want to share the workbook but its too big, and data-source is placed outside the workbook that has the pivot.

    anyway, I also placed the image of 18nam. I cant place 18name with 17nam, I need them separated because if they are in the same sheet names will be duplicated (some staff continued in the organization for both years).

    hopefully you can detect what I am doing wrong. please help.
    Attached Images Attached Images

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: PowerPivot/PivotTable showing same results after relationship building.

    Then, you'd need to create helper column that serves as relationship column.

    In each table, add column where you concatenate PatientName with Year.

    You can now append 18nam to 17nam and will retain unique value for the concatenated column.

    Then use that to build your relationship.

  5. #5
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    104

    Re: PowerPivot/PivotTable showing same results after relationship building.

    that is the way to go! very sharp, thank you very much!

+ 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. PowerPivot Relationship Problem
    By coolasia in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-14-2017, 10:31 PM
  2. Powerpivot relationship not working
    By Bikashmittle in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-22-2017, 11:12 AM
  3. PowerPivot Relationship Issue
    By kellyjo7 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-27-2015, 11:18 AM
  4. [SOLVED] PowerPivot Relationship Problem
    By vinaynaran in forum Excel General
    Replies: 2
    Last Post: 12-11-2014, 10:24 AM
  5. PowerPivot Relationship Confusion In Excel 2013
    By tomhouy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2014, 03:26 AM
  6. Shift rows below PivotTable down when PivotTable expands (PowerPivot)
    By hektisk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 10:19 PM
  7. PowerPivot many to many date relationship
    By chaserracer83 in forum Excel General
    Replies: 1
    Last Post: 10-08-2012, 03:48 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