There are many cases where I like to hide rows manually (via a right-click option), especially for cases where rows are used as intermediate steps in calculations but are not needed when displaying the end result.
I can see how manually hiding rows could mess with an existing filter. However, perhaps you could allow hiding rows when there is not an active filter or when not using a table.