PivotGrid Overview

The PivotGrid allows the user to perform a complex analysis on the visualized data.

It uses the Online Analytical Processing (OLAP) approach to present the result of multidimensional queries in a comprehensive way and also provides a drill-down functionality that represents the underlying data for calculated cells. The PivotGrid uses an instance of the kendo.data.PivotDataSource component as a data source. The PivotDataSource communicates with an OLAP cube instance on HTTP by using the XMLA protocol.

The PivotGrid wrapper for Vue is a client-side wrapper for the Kendo UI PivotGrid widget.

Basic Usage

The following example demonstrates how to initialize the PivotGrid.

<div id="vueapp" class="vue-app">
    <kendo-pivotdatasource ref="pivotdatasource"
        <kendo-pivot-column :name="'Country'" :expand="true"></kendo-pivot-column>
        <kendo-pivot-column :name="'CompanyName'"></kendo-pivot-column>
        <kendo-pivot-row :name="'ContactTitle'"></kendo-pivot-row>

    <kendo-pivotconfigurator id="configurator"

   <kendo-pivotgrid id="pivotgrid"
    .hidden-on-narrow {
        display: inline-block;
        vertical-align: top;

    #pivotgrid {
        width: 58%;

    #configurator {
        width: 41%;
        min-width: 41%;

new Vue({
    el: '#vueapp',
    data: function() {
        return {
            measures: ['Contacts Count'],
            schemaCube: {
                dimensions: {
                    ContactName: { caption: 'All Contacts' },
                    CompanyName: { caption: 'All Companies' },
                    Country: { caption: 'All Countries' },
                    ContactTitle: { caption: 'All Titles' }
                measures: {
                    'Contacts Count': { field: 'CustomerID', aggregate: 'count' }


To initialize the PivotGrid, either:

Initializing with Webpack

  1. Install Kendo UI and add a theme.

    npm install --save @progress/kendo-ui
    npm install --save @progress/kendo-theme-default
  2. Install the Kendo UI PivotGrid package for Vue.

    npm install --save @progress/kendo-pivotgrid-vue-wrapper
  3. Import the Kendo UI packages to the App component. If you use the Kendo UI components more than once in your application, add all Kendo UI-related files to the main.js file. If you use the Kendo UI components once in your application, add the Kendo UI-related files the component where they will be referred.

    import '@progress/kendo-ui' // This will import the entire Kendo UI library
    // As an alternative, you could import only the scripts that are used by a specific widget:
    // import '@progress/kendo-ui/js/kendo.pivotgrid' // Imports only the PivotGrid script and its dependencies
    import '@progress/kendo-theme-default/dist/all.css'
    import { PivotGrid, PivotGridInstaller } from '@progress/kendo-pivotgrid-vue-wrapper'
    new Vue({
       el: '#app',
       components: {

Functionality and Features

In this article