Telerik UI for ASP.NET Core PivotGrid Basic Usage

The Telerik UI for ASP.NET Core PivotGrid control is a powerful data visualization component which enables you to perform operations over multi-dimensional (pivot) data by using the Online Analytical Processing (OLAP) approach to present the result of multi-dimensional queries in a comprehensive way.

The PivotGrid control comes built-in features such as filtering, sorting, and data binding capabilities for both flat and remote data scenarios. In addition, the control also provides Excel and PDF exporting functionality for presenting documents independently from the application software. The control also comes with a supplementary PivotGrid Configurator control which is strongly related to the Telerik UI PivotDataSource.

The current example displays a common use-case scenario for a PivotGrid control which is populated through a service which implements the XMLA standard to easily display, sort, page, and filter data from your Cube.

The ASP.NET Core PivotGrid control is part of Telerik UI for ASP.NET Core, a professional-grade UI library with 110+ components for building modern and feature-rich web applications. The UI for ASP.NET Core PivotGrid is a server-side wrapper for the Kendo UI for jQuery PivotGrid widget and supports an HtmlHelper and a TagHelper mode.

Functionality and Features

• Data binding–The PivotGrid enables you to configure an Ajax data binding to an HTTP accessible Online Analytical Processing (OLAP) cube or to flat data.
• Templates–You can also customize the way the data is visualized in the table.
• Filtering–The PivotGrid enables you to filter its data by the caption value of the members.
• Sorting–The PivotGrid supports sorting by the caption name of the members.
• PDF export–The PivotGrid eables you to export its content to an external PDF file.
• Excel export–You can export the PivotGrid content to a physical Excel file.

This PivotGrid example is part of unique collection of hundreds of ASP.NET Core demos, with which you can see all Telerik ASP.NET Core components and their features in action. View the source code of the demos from the library or directly adapt, and edit them and their theme appearance in Telerik REPL for ASP.NET Core or ThemeBuilder.