Filtering

The KendoReact PivotGrid component supports filtering through the usePivotOLAPService hook or the PivotOLAPService higher-order component.

The filter property is a JavaScript array of FilterDescriptor objects containing the following keys:

• field—The full path to the tuple member. For example, [Date].[Calendar].[Calendar Year].&[2005].
• operator—All operators that work with strings. Note that the component treats field values as strings.
• value—The filter value.

Configuration

To set an initial filter, pass the defaultFilter property to the usePivotOLAPService hook or the PivotOLAPService higher-order component.

The following example demonstrates the basic configuration of the default filter.

Suggested Links

• PivotGrid Sorting
• API Reference of the KendoReact usePivotOLAPService hook
• API Reference of the KendoReact PivotOLAPService HOC