Equation to compare two pivot tables to find correct one and read data

[aldea187]

Hello Everyone,

Been banging my head on my desk trying to read a pivot table in one workbook and pull out data depending on a few things.

I need to get the total number by Div then the country and display in the comparison table. These are coming from separate pivot tables and data sources.

Thanks,

Pivot 1

Div	A
Country	Complete	Replace	Upgrade	Total
Mexico	5	2	1	8
US	6	2	4	12
Canada	8	9	2	19

<tbody>
</tbody>

Pivot 2

Div	B
Country	Complete	Replace	Upgrade	Total
Mexico	3	5	4	12
US	5	1	2	8
Canada	7	3	2	12

<tbody>
</tbody>

Comparison

Div	Country	Total Devices
A	US
B	US
B	Mexico

<tbody>
</tbody>

 

[aldea187]

Hopefully someone can send some ideas today....my head is started to show a bruise from the desk.

 

[aldea187]

Bump