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