All docs
V24.1
24.2
24.1
23.2
23.1
22.2
The page you are viewing does not exist in version 22.2.
22.1
The page you are viewing does not exist in version 22.1.
21.2
The page you are viewing does not exist in version 21.2.
21.1
The page you are viewing does not exist in version 21.1.
20.2
The page you are viewing does not exist in version 20.2.
20.1
The page you are viewing does not exist in version 20.1.
19.2
The page you are viewing does not exist in version 19.2.
19.1
The page you are viewing does not exist in version 19.1.
18.2
The page you are viewing does not exist in version 18.2.
18.1
The page you are viewing does not exist in version 18.1.
17.2
The page you are viewing does not exist in version 17.2.

JavaScript/jQuery PivotGrid Types

CellClickEvent

The type of the cellClick event handler's argument.

import { CellClickEvent } from "devextreme/ui/pivot_grid"
Type:

Object

CellPreparedEvent

The type of the cellPrepared event handler's argument.

import { CellPreparedEvent } from "devextreme/ui/pivot_grid"
Type:

Object

ContentReadyEvent

The type of the contentReady event handler's argument.

import { ContentReadyEvent } from "devextreme/ui/pivot_grid"
Type:

Object

ContextMenuPreparingEvent

The type of the contextMenuPreparing event handler's argument.

import { ContextMenuPreparingEvent } from "devextreme/ui/pivot_grid"
Type:

Object

DisposingEvent

The type of the disposing event handler's argument.

import { DisposingEvent } from "devextreme/ui/pivot_grid"
Type:

Object

ExportingEvent

The type of the exporting event handler's argument.

import { ExportingEvent } from "devextreme/ui/pivot_grid"
Type:

Object

InitializedEvent

The type of the initialized event handler's argument.

import { InitializedEvent } from "devextreme/ui/pivot_grid"
Type:

Object

OptionChangedEvent

The type of the optionChanged event handler's argument.

import { OptionChangedEvent } from "devextreme/ui/pivot_grid"
Type:

Object

PivotGridArea

Specifies the field's area.

Accepted Values: 'column' | 'data' | 'filter' | 'row'

PivotGridDataFieldArea

Specifies the area to which data field headers must belong.

Accepted Values: 'column' | 'row'

PivotGridDataType

Specifies field values for a specific data type.

Accepted Values: 'date' | 'number' | 'string'

PivotGridGroupInterval

Specifies how the field's values are combined into groups for the headers.

Accepted Values: 'day' | 'dayOfWeek' | 'month' | 'quarter' | 'year'

PivotGridRowHeaderLayout

Specifies the layout of items in the row header.

Accepted Values: 'standard' | 'tree'

PivotGridRunningTotalMode

Specifies whether to calculate the running total by rows or by columns.

Accepted Values: 'column' | 'row'

PivotGridSortBy

Specifies how to sort the field's values in the headers.

Accepted Values: 'displayText' | 'value' | 'none'

PivotGridStoreType

Specifies the PivotGridDataSource's storage type.

Accepted Values: 'array' | 'local' | 'odata' | 'xmla'

PivotGridSummaryDisplayMode

Specifies a predefined post-processing function.

Accepted Values: 'absoluteVariation' | 'percentOfColumnGrandTotal' | 'percentOfColumnTotal' | 'percentOfGrandTotal' | 'percentOfRowGrandTotal' | 'percentOfRowTotal' | 'percentVariation'

PivotGridTotalDisplayMode

Specifies where to show the total rows or columns.

Accepted Values: 'both' | 'columns' | 'none' | 'rows'