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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,109,072
Messages
5,526,640
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top