Forum Discussion
B_Real
Advocate IV
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" ...
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.
th3h0bb5
Resolver II
Resolver IIYou can create a calcuated column to do this:
alias = IF([Gender] = "Male", 1, 2)
B_RealAdvocate IV
Advocate IVHey 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.
- B_Real
Great shout, why didn't I think of that! Brain is switched off today ;-)