Components
    • Animation
    • Buttons
    • Charts
    • Common Utilities
    • Conversational UI
    • Data Query
    • Data Tools
    • Date Inputs
    • Date Math
    • Dialogs
    • Drawing
    • Dropdowns
    • Editor
    • Excel Export
    • File Saver
    • Form
    • Gantt
    • Gauges
    • Grid
    • Indicators
    • Inputs
    • Labels
    • Layout
    • ListBox
    • ListView
    • Notification
    • PDF Processing
    • PivotGrid
    • Popup
    • Progress Bars
    • Ripple
    • Scheduler
    • Sortable
    • Tooltip
    • TreeList
    • TreeView
    • Upload
    Sample Applications
    Styling & Themes
    Common Features
    Project Setup
    Changelog

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
Edit In Stackblitz  
Change Theme:

In this article

Not finding the help you need?