Results 1 to 3 of 3

Thread: Apparently related tables yielding results in pivot table as if unrelated

  1. #1

    Apparently related tables yielding results in pivot table as if unrelated



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I'm new here. I just found this forum while trying to troubleshoot an obstacle. Here's my situation:

    I have a very simple PowerPivot setup. I'm using two tables only. I manually related them by a simple whole number key. I got no error message when relating these tables, and I can view and edit the relationship.

    However, when I create a PowerPivot pivot table with this data set, the values are the same in every cell all the way down each column.
    According to TechNet (technet.microsoft.com/en-us/library/gg413446.aspx), this phenomenon is the result of adding unrelated data to the pivot table. I'm definitely using the correct (apparently related) columns from these tables in the pivot table.

    I seem to be at a dead end right now. I can't think of what else to try or check.

    Anyone have any ideas?

    Thanks,
    Jeanette

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,720
    Articles
    76
    Blog Entries
    14
    Hi Jeanette, and welcome to the forum.

    Is there any way you could attach a copy of the workbook with sanitized data so I can see the issue first hand? If not, maybe we can mock something up...
    Ken Puls, CMA, MS MVP (Excel)

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Jeanette,
    when you create a relationship between a fact table and a dimension table the filter context of the fact table does not affect the dimension table. Only the filter context on a dimension table will be propagated to the fact table. Take a look at the relationship and see if this is the case. If you can provide some sample data and explain the relationship then it will be easier to troubleshoot.

Posting Permissions

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