2 pivot tables => 1 summary

[pirdop]

Hello,
I have two pivot tables which output similar information
all I need is to have a summary by currency.

Pivot 1
​

Currency 1 X
​

Currency 2 Y​

Currency 3 M​

Pivot 2​

Currency 1 A
Currency 2 B
​

It might happen that Pivot 1 contains a currency not available in Pivot 2 and vica versa, I want both to appear in the final summary.

Summary:​

Currency 1 X+A
Currency 2 Y+B
Currency 3 M
​

Any ideas how I can achieve that?

Many thanks

 

[pirdop]

I tried to use Vlookup, but the problem is that I can't reference the pivot tables as ranges in the vlookup arguments. Moreover I cannot account for missing/additional currencies in one or the other pivot