Skip to main content
BuyLog In
WPF Controls
Search in…
Docs > WPF Controls > Controls and Libraries > Pivot Grid > Layout > Data Cell Layout
All docs
V23.2
WPF Controls
Prerequisites
What's Installed
.NET/.NET Core Support
Common Concepts
MVVM Support
MVVM Framework
Controls and Libraries
Reporting
Data Grid
Ribbon, Bars and Menu
Charts Suite
Pivot Grid
Get Started
Fundamentals
Binding to Data
Data Shaping
Data Analysis
Layout
Field Groups
Data Cell Layout
Field Location and Order
Field List
Best Fit
Standalone Field Header Areas
Group Value
Save and Restore Layout
Printing and Exporting
End-User Interaction
Appearance
MVVM Support
UI Elements
End-User Capabilities
Examples
Scheduler
Spreadsheet
Rich Text Editor
Tree List
Gauge Controls
Map Control
Layout Management
Windows Modern UI
Printing-Exporting
Data Editors
Navigation Controls
Spell Checker
Property Grid
PDF Viewer
TreeMap Control
Gantt Control
Diagram Control
Windows and Utility Controls
Dialogs, Notifications and Panels
Office File API
Sankey Diagram Control
Sunburst Control
Heatmap Control
Scheduler (legacy)
Localization
Security Considerations
Support, Debug, and Troubleshooting
Redistribution and Deployment
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

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, data field headers are displayed to distinguish between different summary values.

pivotgrid_datafields

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 described in the table below.

Property

Description

PivotGridControl.DataFieldArea

Specifies the area in which the data field headers are displayed. Setting this property to ‘ColumnArea’ or ‘RowArea’ enables the Data header. The following image shows the Data header located within the Row Header Area.

pivotgrid_rowdataheader

PivotGridControl.DataFieldAreaIndex

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

PivotGridControl.DataFieldCaption

Specifies the text displayed within the Data header.

PivotGridControl.DataFieldHeight

Specifies the height of the data field headers.

PivotGridControl.DataFieldWidth

Specifies the width of the data field headers.