Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to use column Expression insted of [ColumnName].
Also rewrite your expression like this:
=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)
Try to use column Expression insted of [ColumnName].
Also rewrite your expression like this:
=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)
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
I'll Try this thanks
This worked with the suppress where value is null...
thanks my friends