PivotGrid Local Data Binding

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.

View Source
Change Theme:

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.

View Source
Change Theme:

In this article

Not finding the help you need?