You filter the data by adding filter criteria so that only the data that meets the criteria appears in a report. To specify how data filters, use the Filter Criteria tab.
The visual layout of the Filter Criteria tab resembles a logic diagram, and you may find it helpful to have a logic diagram for your filters sketched out before you begin using this tab.
This tab enables the entry of a large, complex hierarchy of criteria, with mixed AND and OR specifications. You may also enter as few as one criterion if your filter needs are simple, or no filter criteria at all.
The Filter Criteria tab includes one or more stacks, which are visual representations of a set of criteria. A nested stack uses the same rules and properties as the previous stack. Each stack includes at least two filter criteria or a field criterion and a nested stack, one level lower in the hierarchy. The following image includes an example of both.