PivotGrid Local Data Binding

Premium

The PivotGrid component allows you to use local data.

Basic Usage

To get the PivotGrid running using local data, define the following configuration settings:

• dimensions
• measures
• defaultRowAxes
• defaultColumnAxes
• defaultMeasureAxes

The following demo shows how to configure the PivotGrid component. Each field in the dimensions object points to a field in the local data.

Change Theme

Theme

Loading ...

Custom Dimensions

In the following example, the dimensions do not follow the local data strictly. From the Date field in the local data are created Years, Quarters, Months, and Days dimensions. Rendering and sorting by these fields is adjusted using displayValue and sortValue dimension configuration callbacks.

Change Theme

Theme

Loading ...

Suggested Links

• PivotGrid Sorting
• API Reference of the KendoReact usePivotOLAPService hook
• API Reference of the KendoReact PivotOLAPService HOC