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.

Example
View Source
Edit In Stackblitz  
Change Theme:

Installation

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'
    
    Vue.use(PivotGridInstaller)
    
    new Vue({
        el: '#app',
        components: {
            PivotGrid
        }
    })

Functionality and Features