Pivot tables-- how to set a relationship between two items using an ID

[timmyturnupp]

An Excel workbook (ERPSim Logistics Data) is attached tothis midterm that contains data from the ERPSim Logistics Game with twoworksheets: (a) ERPSim – Purchase Order and (b) ERPSim – Sales. For each of these, build a hypercube (pivottable) that summarizes and compares data from two countries based on the chartbelow:<o></o>

Your Gullnet ID ENDS<o></o> w/ this number<o></o>​	Country I<o></o>​	Country II<o></o>​
1<o></o>​	Japan<o></o>​	Turkey<o></o>​
2<o></o>​	South Korea<o></o>​	Singapore<o></o>​
3<o></o>​	Morocco<o></o>​	Israel<o></o>​
4<o></o>​	Chile<o></o>​	Mexico<o></o>​
5<o></o>​	Israel<o></o>​	Morocco<o></o>​
6<o></o>​	Vietnam<o></o>​	Thailand<o></o>​
7<o></o>​	Singapore<o></o>​	South Korea<o></o>​
8<o></o>​	Thailand<o></o>​	Vietnam<o></o>​
9<o></o>​	Turkey<o></o>​	Japan<o></o>​
0<o></o>​	Mexico<o></o>​	Chile<o></o>​

<tbody>
</tbody>

<o></o>
(a) ERPSim- Purchase Orders:<o></o>
Dimensions: Country, Material, Purchase Order Number<o></o>
Measure: Average Purchase Order Value<o></o>
<o></o>
(b) ERPSim– Sales:<o></o>
Dimensions: Country, Area, Material<o></o>
Measure: Sum of Sales Revenue<o></o>
<o></o>
Submit both spreadsheets with the mid-termdocument. Write a paragraph comparingthe performance of the two countries during the three rounds of the game.


I know how to execute the pivot table just not sure how to display the items together. its 1000+ lines of data to connect together so I cant manually do it connect them. I'm so lost ive tried assigning id number but I cant get them to connect and display the totals together