officefileapi-devexpress-dot-spreadsheet-dot-pivotviewoptions-adfc47d7.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool ShowValuesRow { get; set; }
Property ShowValuesRow As Boolean
| Type | Description |
|---|---|
| Boolean |
true , to display the Values row; otherwise, false.
The default is true.
|
You can access this nested property as listed below:
| Object Type | Path to ShowValuesRow |
|---|---|
| PivotTable |
.View .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 |
|---|---|
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