Filtering data can be done in several ways. As we saw in Chapter 2, Creating New Queries, we can filter the results at the query level when there is a requirement to use a mandatory filter or set of filters that will fetch only specific types of rows that will correspond to the business question; otherwise, the report won't be accurate or useful.
The other level of filtering is performed at the report level. This level of filtering interacts with the data that was retrieved by the user and enables us to eliminate irrelevant rows.
The main question that arises when using a report-level filter is why shouldn't we implement filters in the query level?
Well, the answer has various reasons, which are as follows:
We need to compare and analyze just a part of the entire data that the query retrieved (for example, filtering the first quarter's data out of the current year's entire dataset)
We need to view the data separately, for example, each tab can be filtered by a different value (for...