I have a situation where if value of column2 (which is calculated KF) value is 0 then I need to hide a complete row. This should happen dynamically through query. How to achieve it?
I know zero suppresion and display/hide option in query designer. But this will not work here as my condition is specific to a value in certain column
If : Column1 Column2 Column3 A 30 500 B 0 84 C 400 432 D 0 321 Then: Column1 Column2 Column3 A 30 500 C 400 432