.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

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


bool ShowValuesRow { get; set; }

Property Value

Type Description

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


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