I have a query with ID's and key figure values. I don't want to see the ID with key figure values '0' or if they are blank. How do I suppress the row altogether.
ID Num Den Val
123 1 1 1
234 0 0 x
In the above example, I don't want to see either second or third row, so how do I hide this rows.