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.

Installation

To initialize the PivotGrid, either:

• Use the CDN service, or
• Use Webpack.

Initializing with Webpack

1. Install Kendo UI and add a theme.

   Copy Codenpm install --save @progress/kendo-ui
   npm install --save @progress/kendo-theme-default

2. Install the Kendo UI PivotGrid package for Vue.

   Copy Codenpm 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.

   Copy Codeimport '@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

• Data binding
• Templates
• Excel export
• PDF export

Suggested Links

• Kendo UI PivotGrid for jQuery
• API Reference of the PivotGrid Widget