Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.2.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