Hi everyone
I have loaded a couple of tables into PowerPivot and created a relationship on a unique reference number (URN) column which exists in both tables.
One table contains how much schools spent on certain things in a given year, the other contain's my company's sales to schools in that year. I want to see how much of their total spend was with me.
When I create the pivot table, it says there is no relationship and to create one (even though I have), so I do so, but it doesn't work.
I searched it on the web and found Rob Collie's site and got this page...
http://www.powerpivotpro.com/2013/06/04/
It does say that look up tables are not meant for numeric values. Fine. But I tried the =RELATED() function too and that doesn't work either.
Does anyone have any experience of this and how I fix it?
Many thanks
Alexis
I have loaded a couple of tables into PowerPivot and created a relationship on a unique reference number (URN) column which exists in both tables.
One table contains how much schools spent on certain things in a given year, the other contain's my company's sales to schools in that year. I want to see how much of their total spend was with me.
When I create the pivot table, it says there is no relationship and to create one (even though I have), so I do so, but it doesn't work.
I searched it on the web and found Rob Collie's site and got this page...
http://www.powerpivotpro.com/2013/06/04/
It does say that look up tables are not meant for numeric values. Fine. But I tried the =RELATED() function too and that doesn't work either.
Does anyone have any experience of this and how I fix it?
Many thanks
Alexis