Hide rows based on data values

[ashishpalkar]

Hi There

I have created table , i want to hide rows when values are Item1=North , Item2=East (item1 and item2 are columns in the table)

Thanks in advance.

[Anonymous]

Assuming it is a Straight Table [Chart], then use Set Analysis in the expression.

On this site search for Set Analysis and you'll get loads of hits.

[ashishpalkar]

Hi Thanks for the info, can you send QVW file with sample example.

[ashishpalkar]

I found solution, you can use

=IF(not match(ABC,1,2),ABC)

and check the box which says 'suppress when value is null'