PivotViewOptions.DataCaption Property

Gets or sets the caption for a virtual field named Data (Values in the UI) which appears in a pivot table containing two or more data fields.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

string DataCaption { get; set; }

VB.NET

Property DataCaption As String

Property Value

Type	Description
String	A String value that specifies the Data field caption. The value cannot be null or String.Empty.

Property Paths

You can access this nested property as listed below:

Object Type	Path to DataCaption
PivotTable	.View .DataCaption

Remarks

Use the DataCaption property to set the display name of the Data field that appears in a pivot table with more than one field in the data area. The Data field is used to specify the orientation of multiple data fields (whether they are displayed across columns or shown in rows down the page). By default, the “Values” string used as the Data field caption.

To specify the orientation of multiple data fields in a pivot table, use the PivotLayout.DataOnRows property.