Apparently related tables yielding results in pivot table as if unrelated

boj

New member
Joined
Nov 30, 2011
Messages
1
Reaction score
0
Points
0
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
 
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...
 
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.
 
Back
Top