[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
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
     Hierarchical Value Arrangement
     Compact Layout for Hierarchical Row Values
     Field Location and Order
     Data Cell Layout
     Field Groups
    [Expand]Customization Form
     Save and Restore Layout
    [Expand]Paging and Scrolling
   [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)

Data Cell Layout

The Pivot Grid allows you to create reports with an unlimited number of data fields. When there are two or more data fields, their headers are displayed to distinguish between different summary values. Data cells are located one after another as shown in the image below.

The location and orientation of data field headers is controlled by the Data header. This is a header which is linked with the data field headers. Like any other header, end-users can drag it to different locations to fine-tune a report. The content, size and availability of the Data header are controlled via the options provided by the pivot grid's ASPxPivotGrid.OptionsDataField property. These options are listed and described in the table below.




Specifies the area in which the data field headers are displayed when there are two or more data fields.

Setting this property to PivotDataArea.ColumnArea or PivotDataArea.RowArea enables the Data header. Its position among field headers can be changed using drag-and-drop.


Specifies the position of the data field headers within the hierarchy of field values.


Specifies the text displayed within the Data header.


Specifies the width of the data field headers when they are displayed as row headers.

The animation below shows how to change the location of the Data header via drag-and-drop:

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