PivotGridControl.DataFieldArea Property

Gets or sets the area in which the data field headers are displayed.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v23.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public DataFieldArea DataFieldArea { get; set; }

VB.NET

Public Property DataFieldArea As DataFieldArea

Property Value

Type	Description
DataFieldArea	A DataFieldArea enumeration value that specifies the area in which the data field headers are displayed.

Available values:

Name	Description
None	The data field headers are displayed as column headers. The data header is hidden.
ColumnArea	The data field headers are displayed as column headers. The data header is displayed within the column header area.
RowArea	The data field headers are displayed as row headers. The data header is displayed within the row header area.

Remarks

The DataFieldArea property determines the area in which the data field headers are displayed, when there are two or more data fields. The DataFieldArea property also enables the data header, which allows end-users to move data field headers between and within the column or row header area.

If the DataFieldArea property is set to DataFieldArea.ColumnArea, the data field headers are displayed as column headers. The data header is enabled and displayed within the column header area. The data header can be dragged to a specific position within the column header area or row header area. As a result, the data field headers are moved to an appropriate location.

If the DataFieldArea property is set to DataFieldArea.RowArea, the data header is displayed within the row header area. The data field headers are displayed as row headers:

Setting the DataFieldArea property to DataFieldArea.None, hides the data header. The data field headers are displayed as column headers.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the DataFieldArea property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-pivot-grid-hide-specific-columns-and-row/CS/WpfApp/Data.cs#L34

pivot.ColumnTotalsLocation = FieldColumnTotalsLocation.Far;
pivot.DataFieldArea = DataFieldArea.ColumnArea;
pivot.DataFieldAreaIndex = 1;

VB.NET

wpf-pivot-grid-hide-specific-columns-and-row/VB/WpfApp/Data.vb#L37

pivot.ColumnTotalsLocation = FieldColumnTotalsLocation.Far
pivot.DataFieldArea = DataFieldArea.ColumnArea
pivot.DataFieldAreaIndex = 1