Show Diemsion based on Column Results

[#1]

Hi All,

Does anyone know how to only show the dimesion rows where a columns results are greater than zero, thanks.

Here is some code im using in the "Add Calculated Dimension" box of the Dimensions tab.

=IF([ColumnName] > 0, ETMSpecialty)

Thanks

Martin

[whiteline · Accepted solution]

Try to use column Expression insted of [ColumnName].

Also rewrite your expression like this:

=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)

[thomas_skariah]

Hi Martin,

Another option go for same query and check mark on "Suppress where value is null".

For your reference find the attached application.

Regards,

Tom

[#4]

I'll Try this thanks

[#5]

This worked with the suppress where value is null...

thanks my friends