Filtering
Premium

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.

Change Theme

Theme

Loading ...