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

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:


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>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,112,814
Messages
5,542,643
Members
410,565
Latest member
sebby_joe
Top