Pivot table to compare similar data from 2 tables with different structures

[Horatius]

Hi everyone,

I have tried various forums to find an answer to my question. However it remains unsolved; so I'm pleased to find this forum. Please forgive me if the topic has already been dealt with in another thread, I haven't found it.

Please check this file to understand me better: http://www.cjoint.com/?<wbr>0EEaW4Jl9oq

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 (different cost structure)
- 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 "convert" 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 familiar with excel databases (and conditionnal formulas such as if...vlookup, match, making powerpivot types of relationships etc.)

I hope I make myself more or less clear and you guys can help me out a little bit.

Thanks a lot,

Regards,

H

 

[scottsen]

It's not super clear to me that you know this, so...

You are in the PowerPivot forum: What is PowerPivot? « PowerPivotPro

I think Power Pivot would be a great way to solve your problem, if you want to tackle the learning challenge.

 

[Horatius]

ok sorry, I'm going to try in another forum.
Thanks for the advice

 

[VoG]

Please continue in your other thread.