timmyturnupp
New Member
- Joined
- Mar 16, 2018
- Messages
- 2
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:
<tbody>
</tbody>
<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>
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:
ID ENDS w/ this number | Country I | Country II |
1 | Japan | Turkey |
2 | South Korea | Singapore |
3 | Morocco | Israel |
4 | Chile | Mexico |
5 | Israel | Morocco |
6 | Vietnam | Thailand |
7 | Singapore | South Korea |
8 | Thailand | Vietnam |
9 | Turkey | Japan |
Mexico | Chile |
<tbody>
</tbody>
<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>