Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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