Hello,
I am trying to use a table to relate two tables of data.
Simple.png
The middle table should confirm a relationship between the two tables.
Shouldn't this be enough to create the below pivot table?
Desired Pivot.png
I have created relationships in PowerPivot (file attached) is there something i am missing?
Thanks in advance,
Harvey
Bookmarks