Aliases for values in a column

[B_Real]

Hi, is it possible to manually create alias values for values in a column (in Report view)? An example here would be for gender:

Gender

1

2

I would want to alias "Female" for 1, and "Male" for 2, so that "Female" and "Male" would show up in my reports, rather than 1 or 2. 

In Tableau, this would be done by right clicking the Gender dimension, and selecting 'Aliases...'.

[th3h0bb5]

You can create a calcuated column to do this:

alias = IF([Gender] = "Male", 1, 2)

[B_Real]

Hey yep thanks for the suggestion! That works, but it leaves you with a messy working environment if you have to keep creating new columns. 

[th3h0bb5 · Accepted solution]

Once you've got your new GenderAlais column, you can clean up by hiding the old Gender column by right clicking on that column in the 'Fields' bar and clicking 'Hide'. This should keep your table looking neat and trim.

[B_Real]

Great shout, why didn't I think of that! Brain is switched off today 😉