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

C#

bool ShowValuesRow { get; set; }

VB.NET

Property ShowValuesRow As Boolean

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

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.