Skip to main content
Row

PivotFieldReference.IsValuesReference Property

Gets a value indicating whether the current PivotFieldReference object represents a reference to the virtual “Values” field which appears in a pivot table containing two or more data fields.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

bool IsValuesReference { get; }

Property Value

Type Description
Boolean

true, if the current field represents the “Values” field in the report; otherwise, false.

Remarks

Use the IsValuesReference property to determine whether the specified row or column field represents the virtual “Values” field in a PivotTable report. The “Values” field automatically appears in a pivot table with more than one field in the data area and is used to specify the orientation of multiple data fields in the report. By default, the “Values” field is added to the PivotTable.ColumnFields collection, so that multiple data fields are displayed across the columns, as shown in the image below.

PivotTable_ValuesField

See Also