Calculated dimension

[Mark4]

I have a field aliasing a binary value: [Is Current] = 1 for True, =0 for False in the data load editor

I made this a dimension column in a table aliasing the 1 and 0 as "true" and "false", respectively. 

eg:

if([Is Current] = 1, 'True', 'False')      -   Too easy

But when you select on either option within the table, the filter box at the top of the sheet displays the formula.  I need this to display 'Current or Historical'. I also need to do this without adjusting the script in the data load editor, so all of the code needs to be in the app. 

Any ideas?

Thank you in advance

[StarinieriG · Accepted solution]

Hi,

have you tried to create a master dimension and then use it?

[Mark4]

That did it, thank you!