NOT

NOT is a logical operator that negates the filter it precedes.

If you specify a filter and precede it with NOT, then everything that is specified by the filter is excluded from the computation.

Example:

SELECT Revenues WHERE NOT(Year = 2006 AND Month = 5)
Powered by Atlassian Confluence and Scroll Viewport.