Filtering

The Kendo UI for Angular PivotGrid component supports filtering through the PivotLocalBindingDirective or the PivotOLAPBindingDirective.

Configuration

To define the initial filter state, set the filter property to a collection of FilterDescriptor objects containing the following keys:

• field—The name of the dimension, for example, Region.

If using OLAP cube binding, 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.

The PivotGrid Configurator allows the end user to control the filter settings through the fields' chips menus.

The following example demonstrates basic configuration with initial filter applied and enabled configurator:

Suggested Links

• PivotGrid Sorting
• API Reference of the PivotGridComponent
• Data Binding Local Directive
• Data Binding OLAP Directive