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
=IF([ColumnName] > 0, ETMSpecialty)
Try to use column Expression insted of [ColumnName].
Also rewrite your expression like this:
=aggr(IF((ColumnExpression) > 0, ETMSpecialty), ETMSpecialty)
I'll Try this thanks
This worked with the suppress where value is null...
thanks my friends
Another option go for same query and check mark on "Suppress where value is null".
For your reference find the attached application.
Retrieving data ...