SAP BusinessObjects Enterprise InfoView User's Guide
Combining a sort and filter
When you apply both a sort and a filter to
the same row or column, the returned data reflects both operations. The values
are filtered, and ordered based on the sort operation. If you then remove
either the sort or the filter, the remaining operation is reapplied to the
query's entire data set.