Telerik UI for ASP.NET MVC PivotGrid Basic Usage

Loading Demo...
  • EXAMPLE
  • VIEW SOURCE
index.cshtml
IndexController.cs
ProductService.cs

Also available for:

CLIENT-SIDE API SERVER-SIDE API
devcraft ninja image

The PivotGrid component is part of Telerik UI for ASP.NET MVC, a professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.

Description

The Telerik UI for ASP.NET MVC 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 MVC PivotGrid control is part of Telerik UI for ASP.NET MVC, a professional-grade UI library with 110+ components for building modern and feature-rich web applications. The UI for ASP.NET MVC 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.

Additional Apps

This PivotGrid example is part of a unique collection of hundreds of ASP.NET MVC demos, with which you can see all Telerik ASP.NET MVC 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 the ThemeBuilder.

Support & Learning Resources

Additional Resources