Skip to main content
Row

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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

string DataCaption { get; set; }

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.

SpreadsheetPivotTable_DataCaption

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

See Also