Reconciliation/data comparison with pivot table

[regresss]

Hi, I have 2 tables with 2 categorical variables/columns (product and country) and two real-valued variables to be reconciled/compared against each other. Datasets can have unique categorical variables, e.g. only table B has product = hats or only table B has country = India.

As far as I know, pivot tables are ideal tool for this kind of problems. I know how to start a session with multiple consolidation ranges, but how to use calculated fields, display values from both tables or filter out blank rows or even rows with incomplete data (some blank cells) is beyond my current knowledge and abilities. Any tips?


screen.jpg

[oeldere]

See the attached file.

Please reply if this is how you want.

[regresss]

First off, thank you for your effort. Unfortunately, this is far from what I have in my mind (have everything in one pivot and not merge input data, i.e. two tables). Maybe it's Excel version incompatibility, because it says that your pivot was created in later version of Excel and cannot be updated. This is what I see:

oeldere_solution.jpg