Skip to main content
Row

PivotViewOptions.ShowValuesRow Property

Gets or sets a value indicating whether to display the Values row that may appear when there are multiple fields in the PivotTable data area.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

bool ShowValuesRow { get; set; }

Property Value

Type Description
Boolean

true, to display the Values row; otherwise, false.

The default is true.

Property Paths

You can access this nested property as listed below:

Object Type Path to ShowValuesRow
PivotTable
.View .ShowValuesRow

Remarks

When you add multiple data fields to a pivot table, a virtual field named Data (Values in the UI) automatically appears in the report’s column axis area. If there are no more fields in the column area, an extra row containing the label “Values” is displayed at the top of the pivot table. Use the ShowValuesRow property to hide this row.

ShowValuesRow = true ShowValuesRow = false
PivotTables_View_ShowValuesRow PivotTables_View_HideValuesRow

Use the PivotViewOptions.DataCaption property to replace the default “Values” heading for multiple data fields.

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

See Also