Operators

12 Sep 20251 minute to read

Defines the conditional operators for filtering settings. They are

• Equals - Display the pivot table that matches with the given text or value or date.
• DoesNotEquals - Display the pivot table that does not match with the given text or value or date.
• BeginWith - Display the pivot table that begins with text.
• DoesNotBeginWith - Display the pivot table that does not begins with text.
• EndsWith - Display the pivot table that ends with text.
• DoesNotEndsWith - Display the pivot table that does not ends with text.
• Contains - Display the pivot table that contains text.
• DoesNotContains - Display the pivot table that does not contain text.
• GreaterThan - Display the pivot table when the text or value is greater.
• GreaterThanOrEqualTo - Display the pivot table when the text or value is greater than or equal.
• LessThan - Display the pivot table when the text or value is lesser.
• LessThanOrEqualTo - Display the pivot table when the text or value is lesser than or equal.
• Before - Display the pivot table with preview all records from the given date.
• BeforeOrEqualTo - Display the pivot table with previous all records along with the given date.
• After - Display the pivot table with next all records to the given date.
• AfterOrEqualTo - Display the pivot table with next all records along with the given date.
• Between - Display the pivot table that records between the start and end text or value or date.
• NotBetween - Display the pivot table that does not record between the start and end text or value or date.