Combining two items in a pivot table based on an ID number??

[timmyturnupp]

What steps should I take to group these pivot tables together ?


An Excel workbook (ERPSim Logistics Data) is attached to this midterm that contains data from the ERPSim Logistics Game with two worksheets: (a) ERPSim
– Purchase Order and (b) ERPSim – Sales. For each of these, build a hypercube (pivot table) that summarizes and compares data from two countries based on the chart below:

[TABLE="width: 675"]

<tbody>[TR]
[TD="width: 30%, bgcolor: #ffffff"]
ID ENDS

w/ this number
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Country I
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Country II
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
1
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Japan
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Turkey
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
2
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
South Korea
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Singapore
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
3
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Morocco
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Israel
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
4
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Chile
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Mexico
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
5
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Israel
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Morocco
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
6
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Vietnam
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Thailand
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
7
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Singapore
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
South Korea
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
8
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Thailand
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Vietnam
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
9
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Turkey
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Japan
[/TD]

[/TR]

[TR]
[TD="width: 30%, bgcolor: #ffffff"]
[/TD]

[TD="width: 34%, bgcolor: #ffffff"]
Mexico
[/TD]

[TD="width: 36%, bgcolor: #ffffff"]
Chile
[/TD]

[/TR]

</tbody>[/TABLE]

<dir><dir>ERPSim - Purchase Orders:
<dir><dir>Dimensions: Country, Material, Purchase Order Number
Measure: Average Purchase Order Value
</dir></dir>

ERPSim
</dir></dir><dir><dir>– Sales:
<dir>Dimensions: Country, Area, Material<dir>
Measure: Sum of Sales Revenue
</dir>
</dir>
</dir>
</dir>