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:

  • fieldThe full path to the tuple member. For example, [Date].[Calendar].[Calendar Year].&[2005].
  • operatorAll operators that work with strings. Note that the component treats field values as strings.
  • valueThe 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.

Example
View Source
Change Theme:

In this article

Not finding the help you need?