timmyturnupp
New Member
- Joined
- Mar 16, 2018
- Messages
- 2
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]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
[/TD]
[TD="width: 228, bgcolor: transparent"]
[/TD]
[TD="width: 246, bgcolor: transparent"]
[/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
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD]
Your Gullnet ID ENDS<o
></o
>
w/ this number<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
w/ this number<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Country I<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Country II<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
1<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Japan<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Turkey<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
2<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
South Korea<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Singapore<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
3<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Morocco<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Israel<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
4<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Chile<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Mexico<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
5<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Israel<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Morocco<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
6<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Vietnam<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Thailand<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
7<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Singapore<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
South Korea<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
8<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Thailand<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Vietnam<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
9<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Turkey<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Japan<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
[TR]
[TD="width: 150, bgcolor: transparent"]
0<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 228, bgcolor: transparent"]
Mexico<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[TD="width: 246, bgcolor: transparent"]
Chile<o
></o
>
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
[/TR]
</tbody>[/TABLE]
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
(a) ERPSim- Purchase Orders:<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Dimensions: Country, Material, Purchase Order Number<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Measure: Average Purchase Order Value<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
(b) ERPSim– Sales:<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Dimensions: Country, Area, Material<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Measure: Sum of Sales Revenue<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
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