Refer to a field calculated in another table

[#1]

Hey everybody.

I am having a problem of this kind:

I have two sets of data:

- Historical data

- Current data

I organized the historical data in a pivot chart of 3 dimensions and a calculated field:

dimension 1 ---- dimension 2 ---- dimension 3 --- Expression 1 (calculated)

alpha ---- echo ----- charlie --- 0,5%

bravo ---- echo ----- bravo --- 0,3%

charlie ---- bravo ----- echo ---- 1%

I would like to use expression 1 with Current data, but Current data have a dimension more; my desired result would be something like:

dimension 1 ---- dimension 2 ---- dimension 3 --- dimension 4 ----Expression 1 (calculated)

alpha ---- echo ----- charlie --- echo ----0,5%

alpha ---- echo ----- charlie --- charlie ----0,5%

alpha ---- echo ----- charlie --- delta ----0,5%

bravo ---- echo ----- bravo --- delta ----0,3%

Is it possible or I have to go back to excel and use a vlookup? 🙂

Thanks a lot everybody in advance, I really appreciate your effort,

[brenner_martina]

Hi, community,

don't forget the possibility of varables and/or set analysis!