+ Reply to Thread
Results 1 to 6 of 6

Pivot tables and relationships

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    2,735

    Pivot tables and relationships

    Hi Guys,

    i tried to do something similar like in youtube below:

    https://www.youtube.com/watch?v=-Ijb4aKsAVc

    I have two tables there:

    Screenshot_51.png

    And try to create pivot from 2 connections created from these tables.
    I created relationships:

    Screenshot_52.png

    But still result in pivot table is strange.
    It seems that this is not creating inner join between tables...

    Why?

    Best,
    Jacek
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Pivot tables and relationships

    I'm not answering your exact question, but it is possible using Power Query (see attached).
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    2,735

    Re: Pivot tables and relationships

    Hi kersplash,

    thank you.
    I know how to create use PQ.

    Question is what is the difference where you are creating relationships using Power Pivot?
    Why this is not working?

    Best,
    Jacek

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Pivot tables and relationships

    Can't answer that. I've tried to use this method in the past and scratch my head too, so PQ it is.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    6,434

    Re: Pivot tables and relationships

    Relationships in PP are more of a left outer join between fact table and dimension, not an inner join. Unless you have something in the value area, it won't have any effect.
    Rory
    I drink, and I know things

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    2,735

    Re: Pivot tables and relationships

    thank you rorya !!

    Best,
    Jacek

+ 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. [SOLVED] Reporting from 2 tables and using relationships
    By dsharman in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-19-2017, 04:56 PM
  2. Calculating fields after combining tables with relationships
    By tyip0217 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-07-2017, 03:08 PM
  3. Pivot table Relationships
    By danieljephcott in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-16-2017, 10:52 AM
  4. [SOLVED] Creating relationships between tables (excel 2003)
    By LukeM82 in forum Excel General
    Replies: 1
    Last Post: 08-10-2016, 04:13 PM
  5. Help to Create Relationships in Power Pivot
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-17-2015, 06:15 AM
  6. How to link two tables together with relationships
    By ks100 in forum Access Tables & Databases
    Replies: 2
    Last Post: 02-19-2015, 11:25 AM
  7. Replies: 10
    Last Post: 11-03-2013, 02:24 AM

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