The following table lists the various filter operators for the different types of data in the table columns.

Filter operators

Type of data

Filter operator

Condition description

Textual and Numerical

Equals

Data is equal to the selected filter operand or a value that you enter in the operand box.

Not equals

Data is not equal to the selected filter operand or a value that you enter in the operand box.

Less than

Data is less than the selected filter operand or a value that you enter in the operand box.

Less than or equal to

Data is less than or equal to the selected filter operand or a value that you enter in the operand box.

Greater than

Data is greater than the selected filter operand or a value that you enter in the operand box.

Greater than or equal to

Data is greater than the selected filter operand or a value that you enter in the operand box.

In

Data contains the selected filter operand or a substring that you enter in the operand box.

Not in

Data does not contain the selected filter operand or a substring that you enter in the operand box.

Textual

Contains

Data contains the selected filter operand or text that you enter in the operand box.

Does not contain

Data does not contain the selected filter operand or text that you enter in the operand box.

Like (wildcards)

Data is like the selected filter operand or text and a wildcard character that you enter in the operand box. Use these wildcard characters:

  • "*" to replace any characters
  • "?" to replace one character

Not like (wildcards)

Data are not like the selected filter operand or text and a wildcard character that you enter in the operand box. Use these wildcard characters:

  • "*" to replace any characters
  • "?" to replace one character

Match (regular expression)

Data matches a regular expression that you enter in the operand box.

Does not match (regular expression)

Data does not match a regular expression that you enter in the operand box.

Starts with

Data starts with the selected filter operand or text that you enter in the operand box.

Does not start with

Data does not start with the selected filter operand or text that you enter in the operand box.

Ends with

Data ends with the selected filter operand or text that you enter in the operand box.

Does not end with

Data does not end with the selected filter operand or text that you enter in the operand box.

Numerical

Top

Enter a number, n, in the operand box.

The filter column displays only the highest n numbers out of all the numbers in that column.

Bottom

Enter a number, m, in the operand box.

The filter column displays only the lowest m numbers out of all the numbers in that column.

Top Percentile

Enter a number, x, in the operand box.

The filter column displays only the highest x% out of all the numbers in that column.

Bottom Percentile

Enter a number, y, in the operand box.

The filter column displays only the lowest y% out of all the numbers in that column.