Convert Numerical Values into Text

[Taylorcc]

Hello,

I have created a gender pie chart, and would like to convert the numbers to  text labels:

1 = Male

2 = Female

3 = Other

9 = Not stated/inadequately described.

I have tried to create a master dimension with the below with no luck:

if(gender=1,'Male',

if(gender=2,'Female',

if(gender=3,'Other',

if(gender=9,'Not stated'))

Thank you 

[tresesco · Accepted solution]

Try using dual() like:

Dual(if(gender=1,'Male',if(gender=2,'Female',if(gender=3,'Other',if(gender=9,'Not stated')))),
gender)