Telerik UI for ASP.NET MVC PivotGrid Basic Usage
- EXAMPLE
- VIEW SOURCE
-
Change Theme
defaultDefault Theme
- Main
- Main Dark
- Nordic
- Ocean Blue
- Ocean Blue A11Y
- Purple
- Turquoise
Bootstrap Theme- Main
- Bootstrap 3
- Bootstrap 3 Dark
- Main Dark
- Nordic
- Turquoise
- Turquoise Dark
- Urban
- Vintage
Material Theme- Main
- Arctic
- Lime Dark
- Main Dark
- Nova
Classic Theme- Main
- Green
- Green Dark
- Lavender
- Lavender Dark
- Main Dark
- Metro
- Metro Dark
- Moonlight
- Opal
- Opal Dark
- Silver
- Silver Dark
- Uniform
Fluent Theme- Main
Also available for:
CLIENT-SIDE API SERVER-SIDE APIThe 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.