[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Appearance
   [Expand]MVVM Enhancements
   [Collapse]UI Elements
     Cell
     Column Field
     Column Header Area
     Data Area
     Data Field
     Data Header Area
     Expand Button
     Field Header
     Field Header Context Menu
     Field Value
     Field Value Context Menu
     Filter Field
     Filter Header Area
     Grand Totals
     Header Area
     Header Area Context Menu
     MRU Filter List
     Prefilter Panel
     Row Field
     Row Header Area
     Totals
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[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 Field

Data fields represent fields located in a pivot grid's Data Header Area. The Pivot Grid calculates summaries against data fields. Summary results are displayed within the Data Area.

For numeric data fields the following summary functions can be calculated: Sum, Count, Min, Max, Average, Standard Deviation based upon a sample, Standard Deviation based upon an entire population, Variation based upon a sample and Variation based upon an entire population.

For non-numeric data fields the following summary functions are available: Count, Min and Max.

The following image shows the DXPivotGrid control that contains one data field - Sales.

When there are two or more data fields, DXPivotGrid displays data field headers to distinguish between different summary values.

By default, data field headers are listed along the top of the control. It is possible to display data field headers along the left side of the control by setting the PivotGridControl.DataFieldArea property to DataFieldArea.RowArea. The PivotGridControl.DataFieldAreaIndex property specifies the position of the data field headers within the hierarchy of field values.

Setting the PivotGridControl.DataFieldArea property to DataFieldArea.ColumnArea or DataFieldArea.RowArea enables the data header. This header is linked with data field headers. It can be dragged to a specific position within a column header area or row header area, and data field headers will be moved to the associated location.

The following table lists the main properties affecting the element's appearance.

Field Name and Caption

PivotGridField.FieldName, PivotGridField.Caption

Bound Type

PivotGridField.UnboundType

Summary Type

PivotGridField.SummaryType

Visibility

PivotGridField.Visible

Position

PivotGridField.Area, PivotGridField.AreaIndex

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