Pivot Grid

Jun 13, 2022
6 minutes to read

The DevExpress ASPxPivotGrid is a comprehensive data analysis, data mining, and visual reporting solution for ASP .NET applications and allows you to create a pivot table for multi-dimensional data analysis. Using the Pivot Grid, large amounts of data can be summarized and represented in a cross-tabular format that can be sorted, grouped and filtered. End-users can customize the layout of the report based on their analysis requirements using simple drag-and-drop operations. The Pivot Grid also supports printing and exporting to various file formats (such as PDF, XLS or XLSX), as well as data visualization using the DevExpress Chart Control or KPI. This section contain documentation about the ASPxPivotGrid control.

Create a first Pivot Grid and bind it to data using online tutorials, videos and product documentation.

Online Demos

View all available demos related to the DevExpress Pivot Grid.

Getting Started
	If you are a first-time user, you can refer to the following tutorials, videos and read basic information on the Pivot Grid control. Included Components provides information on which components are supplied with the PivotGridControl. Fundamentals gives you basic information on the purpose and functionality of the Pivot Grid control. These topics demonstrate the control’s basic functionality and provide you with step-by-step instructions on how to create simple applications with the help of the Pivot Grid control. Lesson 1 - Bind a Pivot Grid to an MDB Database Lesson 2 - Bind a Pivot Grid to an OLAP Cube Tutorial Videos
Binding to Data
	Topics in this section describe how to supply ASPxPivotGrid with data. Binding to Data Overview topic provides general information on binding to databases, XML files, OLAP cubes, etc. OLAP Data Source describes how to connect to a cube in a Microsoft Analysis Services server (OLAP server) and provides information on the PivotGridControl functionality limitations imposed when bound to an OLAP server. Database Server Mode topic describes how to connect a Pivot Grid to a database with a large number of records without performance loss. Bind Pivot Grid Fields to Data Columns topic describes how to bind a Pivot Grid field to a data source column. Bind Pivot Grid Fields to Calculated Expressions topic describes how to create a calculated field and display the result of the calculated expression in the Pivot Grid. Bind Pivot Grid Fields to Window Calculations topic describes how to bind a Pivot Grid field to the result of the window calculation.
Data Shaping
	This section describes the Pivot Grid‘s data-related features. This includes data filtering, value formatting, sorting and grouping data, using summaries, etc. Aggregation topic describes how a pivot grid processes (or aggregates) underlying data and displays the results of the calculations. Grouping topic provides general information on grouping field values into categories or ranges. Sorting is used to re-arrange the records to meet current sort settings. Here you will learn how to limit the number of displayed values, sort data by summary or change a sort order. Filtering provides information about different data filtering ways, from simple approaches to complex filter criteria with multiple conditions.
Data Analysis
	This section illustrates the powerful features that help to organize, analyze and interpret Pivot Grid’s data. Integration with the Chart Control describes how to visualize data displayed in the pivot grid using the Chart Control. Set a Pivot Grid control as the Chart control data source and display your data as bars, areas, lines and many other forms. Here you will learn how to customize a Chart control to display Pivot Grid data. Key Performance Indicators (KPIs) introduces a Microsoft Excel-inspired conditional formatting feature that allows you to change the appearance of individual cells based on specific conditions. This feature helps to highlight important information, identify trends and exceptions, and compare data using the collection of format rules. Here you will learn how to change appearances of Pivot Grid Control cells depending upon cell data or an expression.
Data Formatting
	PivotGridControl allows you to format the display text of its data cells, field values, summaries, totals and grand totals before they are displayed on screen. You can apply standard format strings or implement a custom formatter. This section provides general information about data formatting. Standard Formatting topic provides general information about formatting. Custom Formatting topic describes how to display a custom text within individual data cells.
Layout
	This section describes the ways in which you can manage the layout of the ASPxPivotGrid control. This includes changing the layout of fields and data cells, saving and restoring the grid’s overall layout, etc. Field Location and Order topic describes where the data source fields can be located. Field Groups topic provides information on arranging fields into groups. These fields cannot be separated by end-users by dragging one of them to a different area or hiding it on the Customization Form. Compact Layout for Hierarchical Row Values describes how to get more space horizontally without sacrificing the distinction between the hierarchical row values. Customization Form is a window or a standalone control that allows end-users to easily customize the pivot grid layout by hiding and rearranging fields. Save and Restore Layout section describes how to save the information on the Pivot Grid’s layout, and then restore it. This information includes all the settings that control the visibility and size of visual elements, their appearance settings, filtering, sorting, etc. Paging and Scrolling section provides information on how to navigate through data using the pager and scroll bars.
Appearance
	The appearance of the Pivot Grid control can be customized in a number of ways. You can customize style settings for each cell individually, use the control’s style settings or use templates. This section provides all the necessary information about styling and templating. Appearance Customization Customizing Appearance of Individual Cells ASPxPivotGrid Elements that Support Templates
Data Export
	The Pivot Grid Control allows you to export its data to a file or stream in various formats. This section contains the topics that provide more information on this feature.
Design-Time Features
	This section describes design-time editors that enable you to customize field, layout and appearance settings. For example, the ASPxPivotGrid Designer allows you to customize fields and groups and manage client-side events.