Pivot Table Filter Operators

Article Summary

Share feedback

Thanks for sharing your feedback!

The following operators can be used to filter pivot tables using the Data Analytics page.

Value Filter Operators

The following operators are available for use when using value filters.

Top – Shows X items with the greatest values, where X is a number you specify.
Bottom – Shows X items with the lowest values, where X is a number you specify.
Equal – Shows items with values equal to the specified value.
Not equal – Shows items with values not equal to the specified value.
Greater – Shows items with values greater than the specified value.
Greater or equal – Shows items with values greater than or equal to the specified value.
Less – Shows items with values less than the specified value.
Less or equal – Shows items with values less than or equal to the specified value.
Between – Shows items with values between two values (including them).
Not between – Shows items with values not between two values (excluding them).

The following operators are available for use when using conditional filters.

Equal – Shows numbers equal to the specified number.
Not equal – Shows numbers not equal to the specified number.
Greater – Shows numbers greater than the specified number.
Less – Shows numbers less than the specified number.
Greater or equal – Shows numbers greater than or equal to the specified number.
Less or equal – Shows numbers less than or equal to the specified number.
Between – Shows numbers between the specified numbers (including them).
Not between – Shows numbers not between the specified numbers (excluding them).

Equal – Shows strings equal to the specified string.
Not equal – Shows strings not equal to the specified string.
Greater – Shows strings greater than the specified string.
Less – Shows strings less than the specified string.
Greater or equal – Shows strings greater than or equal to the specified string.
Less or equal – Shows strings less than or equal to the specified string.
Between – Shows strings between the specified strings (including them).
Not between – Shows strings not between the specified strings (excluding them).
Begin – Shows strings that begin with the specified string.
Not begin – Shows strings that do not begin with the specified string.
End – Shows strings that end with the specified string.
Not end – Shows strings that do not end with the specified string.
Contain – Shows strings that contain the specified string.
Not contain – Shows strings that do not contain the specified string.

Equal – Shows dates equal to the specified date.
Not equal – Shows dates not equal to the specified date.
After – Shows dates after the specified date.
Before – Shows dates before the specified date.
After or equal – Shows dates after or equal to the specified date.
Before or equal – Shows dates before or equal to the specified date.
Between – Shows dates between the specified dates (including them).
Not between – Shows dates not between the specified dates (excluding them).
Last… – Shows dates of a previous period. The period can be one of the following values: Day, Week, Month, Quarter, Year.
Current… – Shows dates of a current period. The period can be one of the following values: Day, Week, Month, Quarter, Year.
Next… – Shows dates of a next period. The period can be one of the following values: Day, Week, Month, Quarter, Year.

Equal – Shows time periods equal to the specified time period.
Not equal – Shows time periods not equal to the specified time period.
Greater – Shows time periods greater than the specified time period.
Less – Shows time periods less than the specified time period.
Greater or equal – Shows time periods greater than or equal to the specified time period.
Less or equal – Shows time periods less than or equal to the specified time period.
Between – Shows time periods between the specified time periods (including them).
Not between – Shows time periods not between the specified time periods (excluding them).

Was this article helpful?

Table of contents