Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to add a calculated dimension such that if the evaluated expression for my "Expressions" column is a certain value, I want the dimension to display null so that I can supress it and the row will not display. There doesn't seem to be a way to do this and for Expression columns, you can not suppress a row if it is null, you can only hide the column entirely.
example: = if ( [Bucket] != 'NA', FIRM_NAME, null())
Thanks in advance.
= if ( [Bucket] <> 'NA', FIRM_NAME, null())
OR
If(Aggr(sum(Bucket),FIRM_NAME)<>0,FIRM_NAME)