How to hide the row with set analyst

[#1]

Dear All,

     Do you have a method to hide the row with set alalyst.

     For example, there are two expressions "Qty" and "Delivery".

     If the "Delivery" >= "Qty" then hide the row.

     Please give me some suggestions. Thanks a lot

[#2]

Hi,

you can do this by caluculated dimensions.

refer the attached file.

Niranjan M.

[#3]

Hi,

     Thank you for help. It's really useful for me.

     In your example, the calculated dimensions work well.

     But in my case, the qty is changed depend on condition which the user selected.

     In a word, my case is complexer than yours.

     Can you help to analyse my case in the attachment?

     My expected result is hide the row when the open sale qty is less then 0.

     The open sale qty is equal to (qty - delivery qty).

     The delivery qty is dynamic change depend on the date which the user selected.

Thank you very much