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
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