Kendo UI for jQuery

jQuery PivotGrid v2

  • Newly redesigned jQuery PivotGrid for the Excel-like display and analysis of OLAP or flat data.
  • Part of the Kendo UI for jQuery library along with more than 100 professionally designed components developers trust for all their jQuery UI needs.
  • Get up and running quickly with award winning support, detailed documentation, demos, virtual classrooms, and a 3-million-strong developer community.
_Original Kendoka_3
Nasa, Visa, Microsoft Fox, Samsung, IBM World Bank Group, Volvo
  • Overview

    The jQuery PivotGrid v2 is a completely rearchitected and modernized version of the original jQuery PivotGrid. While it boasts the same advanced data binding, filtering, sorting, and more multi-dimensional data analysis features, it is set up for the future development of advanced features.

    See the jQuery PivotGrid v2 demo

    PivotGrid-Overview
  • Data Binding

    Bind the jQuery PivotGrid remotely or locally to OLAP cube or flat data. You can take advantage of the included OLAP service if you already have a cube. If not, connect to flat data and the component will represent it as a cube for you.  The component is designed to be as flexible as possible when it comes to loading, slicing, and analyzing data.

    See the jQuery PivotGrid v2 Data Binding 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.

    PivotGrid-KPIs
  • Filtering

    Adding the jQuery PivotGrid v2 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.

    Filtering
  • 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.

    PivotGrid-Sorting
  • Export to PDF

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

    See the jQuery PivotGrid v2 PDF Export demo

    PivotGrid-ExportPDF
  • 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 v2 Templates demo

  • Theming

    Much like every other component included in Kendo Ui for jQuery, fitting the PivotGrid v2 into your applications theme is easy. Use one of the included themes (Material, Bootstrap, Kendo Default) as they are or customize them and they will be applied consistently across your application. Changing them is as simple as a line of code.

    Theming