Hi everyone,

I have joined two tables together in PowerPivot by a unique identifier. However, when I create a pivot table and try to insert fields from both tables, my results are incorrect. I have created a column and a row by using the first table and then put the values field from the second table. All the values come out to be the same exact number, which is incorrect. The table suggests that a relationship may be needed, but I have already created the relationship on my unique number for every row in the data table.

Any suggestions would be greatly appreciated.

Thanks.