background

Kendo UI for jQuery

jQuery PivotGrid

  • jQuery PivotGrid control for for easy display of multi-dimensional data. Great for data analysis with OLAP & KPIs support, scrolling, sorting, filtering and paging.
  • Part of the Kendo UI for jQuery library along with 100+ professionally-designed components.
  • Includes support, documentation, demos, virtual classrooms, learning resources and more!
PivotGrid Header
  • Overview

    The Kendo UI for jQuery PivotGrid is a powerful data visualization component allowing developers to perform operations over multi-dimensional/ pivot data. Bind it to an OLAP cube or flat data remotely or locally, and get an advanced data view in no time.

    See the jQuery PivotGrid demo

    pivotgrid-olap
  • OLAP Services

    The jQuery PivotGrid uses the Online Analytical Processing (OLAP) approach to present the result of multidimensional queries in a comprehensive way. Populate the jQuery PivotGrid to OLAP cube or service which implements XMLA standard to easily display, sort, page and filter data from your Cube.

    Read the jQuery OLAP Fundamentals documentation

  • KPIs

    Allow your users to display dashboard-type views in their jQuery PivotGrid by supporting OLAP and KPIs. The PivotGrid allows them to sort, filter, and page them to get the view they need.

    See the jQuery PivotGrid KPI demo

    jquery_pivotgrid_olap_kpis
  • Templates

    If you need to define your own templates instead of using the built-in cell elements of the jQuery PivotGrid, you can easily define exactly what to be displayed in a certain cell. The component has many built-in cell templates allowing you to customize each of its parts and even place other controls into the different types of cells.

    See the jQuery PivotGrid Templates demo

  • Export to Excel or PDF

    Allow your users to export the content of the jQuery PivotGrid to Excel or PDF with built-in functionality for both. Thanks to the jQuery Excel and PDF export libraries, you can customize the appearance and layout.

    See the jQuery PivotGrid Excel Export demo

  • Filtering

    Adding the jQuery PivotGrid component to your applications allows you to build basic BI capabilities. You can enable the filtering mechanism in PivotGrid via the API configuration and thus, let your end-users filter their data in Excel-like manner.

    Read the jQuery PivotGrid Filtering documentation

  • Sorting

    Leverage the built-in sorting of  the jQuery PivotGrid to allow end users to sort the Row and Column data in an ascending or descending manner.

    Read the jQuery PivotGrid Sorting documentation

All Kendo UI for jQuery Components

Next Steps

Next Steps