Comparing tables (P&L) with same objects/products but different structures

[Horatius]

Hi everyone,

First, I'm very pleased to find out about this forum :) Please forgive me if the topic has already been dealt with in another thread, I haven't found it.

Please check the file attached to follow.

Here's the issue I'm facing:
- I'm expected to compare different tables (P&Ls) of 2 different types in an efficient way
- They deal with the same objects/products but each time from a different perspective
- The risk is thus great to compare apple and pears
- Fortunately I know what costs of "type A" tables match with which cost(s) of "type B" tables
- I could probably do this manually, line by line, and reconcile both views in a single table with new names for common costs/revenues
- However I have been strongly advised (though without any further help) to do this via 1) a conversion table 2) an excel database
- Supposedly this should enable me to build up pivot tables very smoothly
- I'm not quite familiar with excel databases (and formulas such as vlookup, match, making links etc.)

I hope I make myself more or less clear.

Thanks a lot,

RegardsExemple table conversion problem.xls

[cbatrody]

Hi,

Welcome to the Forum.

I have created a database and a Pivot Table in the attached file. Please check if this suits your requirement. You can filter Revenue & Cost separately for comparing the different Types.


Regards,
Chandra



Please click on ‘ * Add Reputation’ if I was helpful in resolving the issue.

[Horatius]

Exemple table conversion problem v2.xlsHey Chandra, thanks a lot.
I was about to post an additional info on the expected result (see enclosed).
Unless I have missed something, what you propose seems pretty close to what I need...I think what's missing is an intermediary step to have the respective costs/revenues (types A and B) under a common naming...Apparently there's a way to do it automatically (via formula)...I'm afraid that with what you propose I'll still be comparing apples and pears.
Hope there's a way out
kind regards
H