General Information

.NET Subscription

What's Included

DevExpress Installation

DevExpress Code Examples

Common Tools

Project Converter

Assembly Deployment Tool

Localization Service

Quality Assurance and Productivity

CodeRush for Visual Studio (FREE)

TestCafe Studio

Desktop

Controls

WinForms

WPF

VCL

WinUI

Tools

WinForms Skin Editor

WPF Theme Designer

WPF Theme Editor (Legacy)

Coded UI Test Extension

Frameworks and Libraries

XAF - Cross-Platform .NET App UI

XPO - .NET ORM Library (FREE)

XPO Profiler

Core Libraries

Drawing Graphics Library

.NET App Security & Web API Service (FREE)

Web

Mobile

Xamarin UI Controls (FREE)

.NET MAUI (FREE)

Enterprise and Analytic Tools

Reporting

Report and Dashboard Server

BI Dashboard

Office File API

End-User Documentation

Interface Elements for Desktop

Interface Elements for Web

Dashboard for Desktop

Dashboard for Web

JavaScript/jQuery PivotGrid Types

CellClickEvent

The type of the cellClick event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onCellClick

CellPreparedEvent

The type of the cellPrepared event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onCellPrepared

ContentReadyEvent

The type of the contentReady event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onContentReady

ContextMenuPreparingEvent

The type of the contextMenuPreparing event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onContextMenuPreparing

DisposingEvent

The type of the disposing event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onDisposing

ExportingEvent

The type of the exporting event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onExporting

InitializedEvent

The type of the initialized event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onInitialized

OptionChangedEvent

The type of the optionChanged event handler's argument.

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

Type:

Object

Used in:

PivotGrid - onOptionChanged

PivotGridArea

Specifies the field's area.

Type:

Literal Union

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

Used in:

Data Layer - PivotGridDataSource - fields - area

PivotGridDataFieldArea

Specifies the area to which data field headers must belong.

Type:

Literal Union

Accepted Values: 'column' | 'row'

Used in:

PivotGrid - dataFieldArea

PivotGridDataType

Specifies field values for a specific data type.

Type:

Literal Union

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

Used in:

Data Layer - PivotGridDataSource - fields - dataType

PivotGridGroupInterval

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

Type:

Literal Union

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

Used in:

Data Layer - PivotGridDataSource - fields - groupInterval

PivotGridRowHeaderLayout

Specifies the layout of items in the row header.

Type:

Literal Union

Accepted Values: 'standard' | 'tree'

Used in:

PivotGrid - rowHeaderLayout

PivotGridRunningTotalMode

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

Type:

Literal Union

Accepted Values: 'column' | 'row'

Used in:

Data Layer - PivotGridDataSource - fields - runningTotal

PivotGridSortBy

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

Type:

Literal Union

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

Used in:

Data Layer - PivotGridDataSource - fields - sortBy

PivotGridStoreType

Specifies the PivotGridDataSource's storage type.

Type:

Literal Union

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

Used in:

Data Layer - PivotGridDataSource - store - type

PivotGridSummaryDisplayMode

Specifies a predefined post-processing function.

Type:

Literal Union

Used in:

Data Layer - PivotGridDataSource - fields - summaryDisplayMode

PivotGridTotalDisplayMode

Specifies where to show the total rows or columns.

Type:

Literal Union

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

Used in:

PivotGrid - showTotalsPrior

Feedback

Was this page helpful?

Thanks for your feedback!
Any other suggestions? Tell us here.

Additional Feedback

General Information

.NET Subscription

Common Tools

Quality Assurance and Productivity

Desktop

Controls

Tools

Frameworks and Libraries

Web

Controls and Extensions

Tools

Maintenance Mode

Mobile

Enterprise and Analytic Tools

End-User Documentation

General Information

.NET Subscription

Common Tools

Quality Assurance and Productivity

Desktop

Controls

Tools

Frameworks and Libraries

Web

Controls and Extensions

Tools

Maintenance Mode

Mobile

Enterprise and Analytic Tools

End-User Documentation

JavaScript/jQuery PivotGrid Types

PivotGridArea

PivotGridDataFieldArea

PivotGridDataType

PivotGridGroupInterval

PivotGridRowHeaderLayout

PivotGridRunningTotalMode

PivotGridSortBy

PivotGridStoreType

PivotGridSummaryDisplayMode

PivotGridTotalDisplayMode