How to select fields of a variable to make a dimension?

[Waïl_Riachi_Sanofi]

Hello,

I have a variable "dpt" containing the names of departments.

I would like to create a dimension that only retrieves some of the departments from this variable.

How to do ?

Thank you in advance,

Waïl

/

Bonjour,

J'ai une variable "dpt" contenant des noms de départements.

J'aimerais créer une dimension qui récupère seulement certains des départements de cette variable.

Comment faire ?

Merci d'avance,

Waïl

[marcus_sommer]

Maybe something like this:

if(match(departments, 'dep1', 'dep2', ...), departments, 'other') as departments 

- Marcus

[Waïl_Riachi_Sanofi]

Thank you for your answer but it doesn't work...

- Waïl