Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
will that disappear row from the table or will show blank value in a column?
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.
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.......