PivotGridV2 Overview

The Kendo UI PivotGridV2 represents multidimensional data in a cross-tabular format.

Kendo UI for jQuery Kendoka image

The PivotGridV2 is part of Kendo UI for jQuery, a professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

Compared to the legacy PivotGrid, the new PivotGridV2 offers a brand new design, and its future-proof architecture allows the implementation of many upcoming functionalities. As PivotGridV2 aims to replace the legacy PivotGrid, it is recommended to use the PivotGridV2 in your new projects. For information about the differences between the PivotGrid and PivotGridV2, refer to the Comparison article.

Basic Configuration

  1. Start with the initialization of the PivotGridV2 widget. Create the widget by defining an HTML <div> element.

    <!-- Define  the HTML div that will hold the PivotGridV2 -->
    <div id="pivotgrid">
    </div>
    
  2. Configure PivotGridV2 to work with the Adventure Works cube that is hosted on https://demos.telerik.com.

    <script>
        $(document).ready(function () {
            $("#pivotgrid").kendoPivotGridV2({
                height: 700, // Define the height of the widget.
                dataSource: {
                    type: "xmla", // Define the type of the DataSource.
                    columns: [{ name: ['[Date].[Calendar]'] }], // Specify a columns dimension.
                    rows: [{ name: ['[Geography].[City]'] }], // Specify a rows dimension.
                    measures: [{ name: ['[Measures].[Reseller Freight Cost]'] }], // Specify a measure to display.
                    transport: {
                        connection: {
                            catalog: "Adventure Works DW 2008R2", // Specify the name of the catalog.
                            cube: "Adventure Works" // Specify the name of the cube.
                        },
                        read: 'https://demos.telerik.com/olap/msmdpump.dll' // Specify the url of the service.
                    }
                }
            });
        });
    </script>
    

The following image demonstrates the output from the previous example.

Kendo UI PivotGridV2

Functionality and Features

Referencing Existing Instances

To reference an existing PivotGridV2 instance, use the jQuery.data() method. Once a reference has been established, use the PivotGridV2 API to control its behavior.

The following example demonstrates how to access an existing PivotGridV2 instance.

var pivotgrid = $("#pivotgrid").data("kendoPivotGridV2");

See Also

In this article
Not finding the help you need? Improve this article