I know it's been a long time since you posted this! But, one option may be to create a calculated field on top of what you have that is similar to the following:
if last()=0 then 'show' else 'hide' end
Then, place this on the view, right click on the 'hide' column/row and select Hide. The data is not being filtered out, it is only being hidden. The data should also update appropriately.
Hope this helps!