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>
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]

Your Gullnet ID ENDS<o></o>

w/ this number<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Country I<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Country II<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

1<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Japan<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Turkey<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

2<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

South Korea<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Singapore<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

3<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Morocco<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Israel<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

4<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Chile<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Mexico<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

5<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Israel<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Morocco<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

6<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Vietnam<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Thailand<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

7<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Singapore<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

South Korea<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

8<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Thailand<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Vietnam<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

9<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Turkey<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Japan<o></o>​

[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]

0<o></o>​

[/TD]
[TD="width: 228, bgcolor: transparent"]

Mexico<o></o>​

[/TD]
[TD="width: 246, bgcolor: transparent"]

Chile<o></o>​

[/TD]
[/TR]
</tbody>[/TABLE]
<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