Select jerarquic dimenssion with field?

[#1]

Hi

I have this inline table

NAME

UP

DOWN

i wanna have ONE object and if i select in a list table "up" or "up" and "down" i use JERARQUIC DIMMENSION 1

but if i select "down" i use JERAQUIC DIMENSION 2

all of this in one object

thank you

Greetings

[Peter_Cammaert]

Add a calculated dimension that says:

=if(match(getfieldselections(NAME, ';'), 'UP'), [JERARQUIC DIMMENSION 1], [JERARQUIC DIMMENSION 2])

[#3]

thank you,

what is the reason of the ; ?

thank you

[Peter_Cammaert · Accepted solution]

Separates multiple values. If you have UP & DOWN selected in field NAME, the function will return 'DOWN;UP'.