Dynamic Dimension for valuelist

[robin_heijt]

Hi,

I have created a pivot table with 1  row dimension (Country), and as the column dimension I use value list with 4 values.

3 values are based on table 1

1 value is based on table 2

The tables are not linked together.

I would like to have my measures calculated on Country(Table 1) for the first 3 values

And the measure for the 4th value based on Country (Table 2).

How can I create a dynamic dimension which essentially includes Country(Table 1)&Country(Table 2)?

Thanks.

[sasikanth]

Hi,
use the below expression:

if( valueList('value1','value2','value3','value4')= 'value1'
OR
valueList('value1','value2','value3','value4')= 'value2'
OR
valueList('value1','value2','value3','value4')= 'value3'
, Sum(Value-Table1),

IF(valueList('value1','value2','value3','value4')= 'value4',
sum(Value-Table2)
)
)