Forum Discussion
Advocate IVAliases for values in a column
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...'.
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.
4 Replies
- th3h0bb5
Resolver II
You can create a calcuated column to do this:
alias = IF([Gender] = "Male", 1, 2)
B_RealHey 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
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.