The AND NOT operator

The following images show the initial report with no filter, and the resulting report after two filter qualifications are applied and joined with AND NOT. The initial report with no filter appears as follows:

After the filter (Year = 2020) And Not(Region = Northeast) is applied, the report appears as follows:

The following diagram shows the impact of the AND NOT operator on a result set.

As shown by the shaded area, revenue generated in 2020 in any region except the Northeast is returned in the result set.