Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It's possible hide all line when some column have a especifc value
like: column = 'Prata' hide all line
Hi
To hide the row, let's for the sake of example, assume that the column to check is column 3:
For each expression (except column 3), change the original expression to:
If(Column(3) = 'Prata', 0, <original column expression here>)
And then make sure that suppress zeroes is enabled for the table. This should work on straight tables and pivot tables.
Regards
Jonathan
Hi,
You mean hide all the rows in the table(need to display empty table)?
Celambarasan
Hi
Or do you mean to hide the line if a column contains the value 'Prata'?
Regards
Jonathan
hide the line if a column contains the value 'Prata'
Hello,
In straight table you can hide the columns.
GoTo -> Properties -> Presentaion -> choose the column which you want to hide -> check on Condition radio button
and paste this code =if(substringcount (Concat(FieldName),'Prata')=1,False(),True()) in text box.
Hope it helps you.
Hi
To hide the row, let's for the sake of example, assume that the column to check is column 3:
For each expression (except column 3), change the original expression to:
If(Column(3) = 'Prata', 0, <original column expression here>)
And then make sure that suppress zeroes is enabled for the table. This should work on straight tables and pivot tables.
Regards
Jonathan