Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi John,
Some of the columns are dimensions and some are expressions, I will try to implement your suggestion.
Regards,
Kingshuk