Hiding the entire row based on a particular value in a column

[#1]

Hi,

I have a requirement where I need to create a report and hide certain rows based on a particular value.

For Eg. I have 10 columns and if any of the column value is say ''DUMMY", I need to hide the entire row where it appears.

Can anyone have any solution for this.

Regards,

Kingshuk

[johnw]

Is it a straight table? Are the columns you're talking about the dimensions? It's a little ugly if you have very many expressions, but you could put an if() around every expression in the table, and then suppress nulls.

if(not match('Dummy',Field1,Field2,Field3,...,Field10),your current expression)

[#3]

Hi John,

Some of the columns are dimensions and some are expressions, I will try to implement your suggestion.

Regards,

Kingshuk