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!
-
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.
-
OLAP Services
-
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.
-
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.
-
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.
-
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.
-
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.
