Remove Blank records from BEx Query

Dear All,

Please have a look at below attached screen shot , where i want to remove the rows entries where the no. of rows count is blank. I dont want to show those dates in the Query result where the count is blank.

I have tried with Query property -> Rows/Cols -> Supression with Zero , but it is not working.

Please do the needful as soon as possible.

Regards,
Sanjay Gajera

+91 89050 74894