New to Kendo UI for Angular? Start a free 30-day trial


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


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:

View Source
Change Theme:

In this article

Not finding the help you need?