Restricting all other columns based on condition on one

[rsdhavle]

Hi,

I have columns lets say A,B,C,D all have different expressions. my  C column has values 10%,20%, 30%..so on. I need to show data in the completed table only if value on My C column is more than 20%. For example lets say a value in a C column is 10% then that row should disappear irrespective of values in other columns of the table. What is the approach to do so?

[swuehl]

I think you need to add a condition to your other columns, checking the result of your column C:

=if( "C" > 0.2, YOUROTHEREXPRESSION,0)

[rsdhavle]

will that disappear row from the table or will show blank value in a column?

[swuehl]

If you enable the option 'Suppress zero values' on presentation tab and if you add a similar condition to all your columns (except C, of course), the row should disappear.

[ashishkalia]

Bro u can use  if( "C" > 0.2, calculated dimension/dimension,0) at the primary dimension.
in that case the dimension will be disabled nd hence the complete row will be dissipated.

cheers.......