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 100+ professionally-designed components.
  • Includes support, documentation, demos, virtual classrooms, learning resources and more!
  • 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

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

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

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

  • 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

  • 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 application's theme is easy. Use one of the included themes (Material, Fluent, 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.


All Kendo UI for jQuery Components

Next Steps

Next Steps