[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Collapse]Pivot Grid
   [Expand]Getting Started
     Product Class Structure
     Information Presentation Basics
     Hierarchical Value Presentation
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)


Pivot Grid Fields represent data source fields and supply specific data to ASPxPivotGrid. Fields are visually represented by field headers that can be moved between control areas using drag-and-drop. Dragging fields between the areas modifies the layout of the report.

To create a report in ASPxPivotGrid, create pivot grid fields and position them within appropriate areas.

A field can be positioned within one of four areas: Column, Row, Data, and Filter Header Area. The field's function is determined by the area in which it is displayed:

  • position a field within the Column Header Area to list its values along the control's top edge. This field's values will represent column headers;
  • position a field within Row Header Area to list its values along the control's left edge. This field's values will represent row headers;
  • position a field within Data Header Area to calculate summaries against this fields. The summaries will be calculated for all the cells; each cell is identified by a specific column and row;
  • position a field within the Filter Header Area to make this field available for further customizations. For instance, it can be dragged to a different area later. In addition, an end-user can filter data against a filter field via the filter drop-down.

Expanded Binding Basics

ASPxPivotGrid supports bound and unbound fields. A bound field retrieves data from a field in a pivot grid's data source. An unbound field is not associated with a data source and should be populated with data manually. To learn more on unbound fields, see Unbound Fields.

To bind a pivot grid field to a data source field, use the PivotGridField.FieldName property. This property provides the name of the data field bound to a pivot grid field. The PivotGridFieldBase.UnboundType property must be set to UnboundColumnType.Bound.

To learn more, see Binding to Data Overview and Binding to OLAP Data Sources.

Expanded Example

Is this topic helpful?​​​​​​​