Filtering

The PivotGrid supports filtering both in the OLAP and flat data-binding scenarios.

The PivotGrid uses kendo.data.PivotDataSource to perform label filtration. However, it filters only by the caption value of the members.

The filter descriptor is similar to the filter option of the kendo.data.DataSource and contains the following options:

• 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.

See Also

• Filtering a Dimension in the PivotGrid
• Basic Usage of the PivotGrid (Demo)
• PivotGrid JavaScript API Reference