Comparing data between 2 pivot tables

[MachuPichu92]

Hello to all,

I'm currently working on some project, to compare data between 2 different tables (1 for exchange data, 1 for "our" data).

Both tables share common headers as Delivery Date, Type (buy, sell), quantity and amount (see screenshot below).

My goal is to match data between these 2 tables based on delivery date + type in order to get differences in quantity and amount.

I would appreciate if you could post some vba code to create difference between quantites and amounts.


Thanks you!


Has anyone met this situation before? I was trying to create consolidated pivot table or calculated items (difference) but with no luck.

 

[WashingtonDC74]

Hi MachuPichu,

Have you try the Calculated field on the PivotTableAnalyze tab ?

Otherwise, I don't get your point...

 

[MachuPichu92]

Hi MachuPichu,

Have you try the Calculated field on the PivotTableAnalyze tab ?

Otherwise, I don't get your point...

How can I create calculated field if these are 2 pivots and not 1?

 

[MachuPichu92]

Hello,

does anyone have an idea on how to compare QTY and AMOUNT between these 2 tables?

thanks a lot!