JavaScript/jQuery PivotGrid Methods

|

jQuery

|

The Chart to be bound to the PivotGrid.
Accepts the Chart's instance, jQuery element or container selector.

integrationOptions:

The Chart's configuration.

Object structure:

Name	Type	Description
alternateDataFields	Boolean	Default Value: true. Specifies whether to alternate data fields in the resulting chart or not. Applies only if the PivotGrid contains several data fields.
customizeChart	Function	Allows you to customize the Chart's appearance.
customizeSeries	Function	Allows you to customize the series.
dataFieldsDisplayMode	String	Default Value: "splitAxes". Accepts one of the following values. "singleAxis" - values of all data fields are displayed on a single value axis. "splitAxes" - each data field gets an individual value axis. Applies only if putDataFieldsInto is "series". "splitPanes" - each data field gets an individual pane. Applies only if putDataFieldsInto is "series". Applies only if the PivotGrid contains several data fields.
inverted	Boolean	Default Value: false. If true, row field values go to the chart arguments and column field values form series. If false - vice versa.
processCell	Function	Allows you to process cell data before the Chart visualizes it.
putDataFieldsInto	String	Default Value: "series". Accepts one of the following values. "args" - data fields go to the chart arguments. "series" - data fields go to the chart series.

Return Value:

| null

Unbinds the Chart. If null, then binding failed.

Main article: Integration with Chart

View Demo

defaultOptions(rule)

Specifies the device-dependent default configuration options for this component.

Parameters:

rule:

The component's default device options.

Object structure:

Name	Type	Description
device	Device \| Array<Device> \| Function	Device parameters. When specifying a function, get information about the current device from the argument. Return true if the options should be applied to the device.
options	Object	Options to be applied.

Name

Type

Description

device

Device

|

Array<Device>

|

Device parameters.
When specifying a function, get information about the current device from the argument. Return true if the options should be applied to the device.

options

Options to be applied.

defaultOptions is a static method that the widget class supports. The following code demonstrates how to specify default options for all instances of the PivotGrid widget in an application executed on the desktop.

jQuery

JavaScript

DevExpress.ui.dxPivotGrid.defaultOptions({ 
    device: { deviceType: "desktop" },
    options: {
        // Here go the PivotGrid options
    }
});

Angular

TypeScript

import PivotGrid from "devextreme/ui/pivot_grid";
// ...
export class AppComponent {
    constructor () {
        PivotGrid.defaultOptions({
            device: { deviceType: "desktop" },
            options: {
                // Here go the PivotGrid options
            }
        });
    }
}

Vue

<template>
    <div>
        <DxPivotGrid id="pivotGrid1" />
        <DxPivotGrid id="pivotGrid2" />
    </div>
</template>
<script>
import DxPivotGrid from "devextreme-vue/pivot-grid";
import PivotGrid from "devextreme/ui/pivot_grid";

PivotGrid.defaultOptions({
    device: { deviceType: "desktop" },
    options: {
        // Here go the PivotGrid options
    }
});

export default {
    components: {
        DxPivotGrid
    }
}
</script>

React

import React from "react";
import dxPivotGrid from "devextreme/ui/pivot_grid";
import PivotGrid from "devextreme-react/pivot-grid";

class App extends React.Component {
    render () {
        dxPivotGrid.defaultOptions({
            device: { deviceType: "desktop" },
            options: {
                // Here go the PivotGrid options
            }
        })
        return (
            <div>
                <PivotGrid id="pivotGrid1" />
                <PivotGrid id="pivotGrid2" />
            </div>
        )
    }
}

export default App;

dispose()

Disposes of all the resources allocated to the PivotGrid instance.

After calling this method, remove the DOM element associated with the widget:

jQuery

JavaScript

$("#myPivotGrid").dxPivotGrid("dispose");
$("#myPivotGrid").remove();

Angular

HTML

<dx-pivot-grid #pivotGridVar id="myPivotGrid"></dx-pivot-grid>

TypeScript

import { ..., ViewChild } from "@angular/core";
import { DxPivotGridComponent } from "devextreme-angular";
// ...
export class AppComponent {
    @ViewChild("pivotGridVar", { static: false }) pivotGrid: DxPivotGridComponent;
    // Prior to Angular 8
    // @ViewChild("pivotGridVar") pivotGrid: DxPivotGridComponent;

    removePivotGrid (e) {
        this.pivotGrid.instance.dispose();
        document.getElementById("myPivotGrid").remove();
    }
}

element()

Gets the root widget element.

Return Value:

HTMLElement | jQuery

An HTML element or a jQuery element when you use jQuery.

endUpdate()

Refreshes the widget after a call of the beginUpdate() method.

Main article: beginUpdate()

exportToExcel()

Exports pivot grid data to the Excel file.

focus()

Sets focus on the widget.

getDataSource()

Gets the PivotGridDataSource instance.

Return Value:

PivotGridDataSource

The PivotGridDataSource instance.

This method is commonly used to link the pivot grid with the PivotGridFieldChooser widget.

getFieldChooserPopup()

Gets the Popup instance of the field chooser window.

Return Value:

Popup

The Popup instance.

Use this method to show and hide the field chooser window programmatically. The code below demonstrates how you can display the field chooser from code.

JavaScript

pivotGrid.getFieldChooserPopup().show();

getInstance(element)

Gets the instance of a widget found using its DOM node.

Parameters:

element:

DOM Node

|

jQuery

The widget's container.

Return Value:

The widget's instance.

getInstance is a static method that the widget class supports. The following code demonstrates how to get the PivotGrid instance found in an element with the myPivotGrid ID:

// Modular approach
import PivotGrid from "devextreme/ui/pivot_grid";
...
let element = document.getElementById("myPivotGrid");
let instance = PivotGrid.getInstance(element) as PivotGrid;

// Non-modular approach
let element = document.getElementById("myPivotGrid");
let instance = DevExpress.ui.dxPivotGrid.getInstance(element);

instance()

Gets the widget's instance. Use it to access other methods of the widget.

Return Value:

This widget's instance.

off(eventName)

Detaches all event handlers from a single event.

Parameters:

eventName:

The event's name.

Return Value:

The object for which this method is called.

off(eventName, eventHandler)

Detaches a particular event handler from a single event.

Parameters:

eventName:

The event's name.

eventHandler:

The event's handler.

Return Value:

The object for which this method is called.

on(eventName, eventHandler)

Subscribes to an event.

Parameters:

eventName:

The event's name.

eventHandler:

The event's handler.

Return Value:

The object for which this method is called.

Use this method to subscribe to one of the events listed in the Events section.

on(events)

Subscribes to events.

Parameters:

events:

Events with their handlers: { "eventName1": handler1, "eventName2": handler2, ...}

Return Value:

The object for which this method is called.

Use this method to subscribe to several events with one method call. Available events are listed in the Events section.

option()

Gets all widget options.

Return Value:

The widget's options.

option(optionName)

Gets the value of a single option.

Parameters:

optionName:

The option's name or full path.

Return Value: any

This option's value.

option(optionName, optionValue)

Updates the value of a single option.

Parameters:

optionName:

The option's name or full path.

optionValue: any

This option's new value.

option(options)

Updates the values of several options.

Parameters:

options: