+ Reply to Thread
Results 1 to 5 of 5

Excel 2013 Power Pivot: Pivot Table not showing related fields

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2010
    Posts
    3

    Excel 2013 Power Pivot: Pivot Table not showing related fields

    Hi All:

    In Excel 2013 I have 2 tables and I built a model with those 2 tables (I used the function 'Related' in one of them and it worked so the model it is Ok). However, when I built a Pivot Table for this model the relationship didn't worked:

    - If I add a field from the first table to the Pivot Table and then I add a field from the second table, then for each value in the first table all the values in the second table are listed, so why I don't see just the related field?. Do I need to do something else?. By the way, this is my first use of Power Pivot.

    Thank you very much

    Regards

    Carlos Negroni

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Excel 2013 Power Pivot: Pivot Table not showing related fields

    Are you pulling in fields from the same table once things are related?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Excel 2013 Power Pivot: Pivot Table not showing related fields

    Hi Mike:

    Thanks for your answer. These are the 2 test tables and after that the result in the Pivot Table. As you can see, for each user I get the list of all the roles instead of seing the related role (I marked the related roles according to the relationship in the data model):

    roleid name id description
    3 carlos 1 senior
    1 victor 2 junior
    1 mauricio 3 pmo
    2 cristian

    name description
    carlos junior
    pmo
    senior
    cristian junior
    pmo
    senior
    mauricio junior
    pmo
    senior
    victor junior
    pmo
    senior

    So what should I do to see just the related values in the Pivot Table?

    Thank you very much

    Regards

    Carlos Negroni

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Excel 2013 Power Pivot: Pivot Table not showing related fields

    Can you post a sample dataset with powerpivot and whatnot? I have trouble following unless I am IN excel

  5. #5
    Registered User
    Join Date
    06-13-2012
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Excel 2013 Power Pivot: Pivot Table not showing related fields

    Hi mikeTRON:

    I uploaded my test file here: http://wikisend.com/download/409548/...ivot_Test.xlsx I hope you can find what the problem is.

    Thank you very much

    Regards

    Carlos Negroni

+ 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: 2
    Last Post: 02-12-2014, 11:14 PM
  2. Pivot Table FRom Power Pivot Returns Sum Of Entire Field
    By goss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-26-2013, 07:34 PM
  3. pivot table from Power Pivot not displaying thousand separator/comma
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2013, 01:05 PM
  4. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 PM
  5. Pivot table fields not showing
    By ctenanthe in forum Excel General
    Replies: 2
    Last Post: 09-08-2010, 06:07 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