Creating nested filters
Nested filters are used when the query requires a more complex set of conditions.
Nested filters mean there is a priority set to a group of conditions while the other group or groups are set with a different priority.
The most basic rule is that the AND operation is prioritized before the OR operation.
Nesting filters allow us to ask more complex questions but implement them easily with the drag-and-drop method.
Getting ready
We are required to set these conditions in the query: retrieve the sales revenue for USA for the car maker Leep (there is an AND relation between the first two conditions) OR retrieve Model Colours that equal BLACK.
How to do it...
We will create the three conditions by dragging-and-dropping the relevant ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
