Creating a new Dimension from an existing one

[DellaCruze]

Hi everyone,

I want to create a new Dimension from an Existing one. 

Just like displayed in this graphic:

I tried it with multiple if-statements in the chart and in the script, but i guess i am too deep into EXCEL 😉
The result was always the first expression like "if(Movement = 1 or 2 or 3 or 14, 'Logistics', if(...)) --> Logitics" but it would never return the other expressions.

Hopefully someone can help and explain to me .

BR and many thanks in advance

[jwjackso · Accepted solution]

Try

If(Movement = 1 or Movement = 2 or Movement = 3 or Movement = 14,'Logistics',If(...))

or 

Pick(Movement,'Logistics','Logistics','Logistics','Production','Production',....)

[DellaCruze]

Thank you @jwjackso !

The solution was this simple.
Your first suggestion worked flawlessly in the script.

BR