Hello all,
I'm a relatively new user of power pivot, and have been able to use it without too many problems so far but I'm currently stuck with creating a relationship between two sets of data using a single lookup table.
Data set "NA" comes from same-structure files located in a folder, and files are added to this folder occasionally.
Data set "EA" comes from same-structure files located in another folder, and files are added to this folder occasionally.
In data set "NA" I have codes & names, and in data set "EA" I have codes and amounts. The codes appear multiple times in each data set.
I want to display the codes, names and amounts in a single pivot table.
My lookup table lists the codes as the unique value/lookup and I am trying to connect that code to each data set.
When I manually create the relationship between NA code and Lookup code, then another relationship between EA code and Lookup code, it doesn't work.
The result is repeated/identical values in my pivot table.
Can anyone help please?
Sample files attached.
Thanks,
Shannon
Bookmarks