dimension using valuelist with 2 not equal values

[Anonymous]

Hello,

For a project, I must create a tab with valuelist.

But, if I choose one country I want to see 2 values in my list, but for an other country I want to see 3 values in my list.

For Example,

if I choose USA, I want to see : ValueList('Revenue','Cost').

if I choose NORDIC, I want to see : ValueList('Revenue','Cost','Managed').

Actually, I create 2 tabs and I use Conditionnal view, but if it's possible I prefere used one tab.

Do you know if it's possible?

Regards

Philippe

[#2]

many ways but you need to be more specific

could you send sample file with table you are talking about?

[Anonymous]

In the first case, when I 've selected for example USA, I must see this list :

In the second case, when I've selected Canada, I must see this list:

ValueList are differents, so actually I 've done 2 tabs:

One for USA which is hidden when I'v selected Canada

One for Canada which is hidden when I'v selected USA

On the properties, I tried to use the formula for dimensions:

"=If(Country = 'USA',ValueList('External Collection',.......,'Capex'),ValueList('DOR (in days)',.....,'Capex')

It doesn't work.

The difficulty, there is not equal lines.

Philippe