The following comparative operators can be set under Condition in the Standard Filter dialogue box.
Comparative operator | Effect |
---|---|
Equal (=) | Shows values equal to the condition. |
Less than (<) | Shows values less than the condition. |
Greater than (>) | Shows values greater than the condition. |
Less than or equal to (< =) | Shows values that are less than or equal to the condition. |
Greater than or equal to (> =) | Shows values that are greater than or equal to the condition. |
Not equal (< >) | Shows the values not equal to the condition. |
Largest | Shows the N (numeric value as parameter) largest values. |
Smallest | Shows the N (numeric value as parameter) smallest values. |
Largest % | Shows the largest N% (numeric value as parameter) of the total values. |
Smallest % | Shows the smallest N% (numeric value as parameter) of the entire values. |