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

PivotDataField Members

In This Article
Represents a reference to a PivotField object that is currently shown as a data field.

#Properties
Show Inherited Hide Inherited

Name Description
BaseField Returns the base field used by the “Show Values As” calculation option applied to the data field.
BaseItem Returns the base item used by the “Show Values As” calculation option applied to the data field.
BaseItemType Returns the type of the base item used by the “Show Values As” calculation option applied to the data field.
Field Provides access to the underlying pivot field referenced by the current object. Inherited from PivotFieldReferenceBase.
Name Gets or sets the name of the data field.
NumberFormat Specifies a number format (in the invariant culture) used to display summary values within the data field.
NumberFormatLocal Specifies a local number format used to display summary values within the data field.
Position Returns or specifies the field position in the collection that corresponds to the PivotTable area where this field is located. Inherited from PivotFieldReferenceBase.
ShowValuesAs Gets the type of calculation applied to the data field in addition to the actual value of the field.
SummarizeValuesBy Gets or sets the summary function used to calculate values in the data field.

#Methods
Show Inherited Hide Inherited

Name Description
GetPivotData(PivotItemReference[]) Retrieves summary data for the specified items of the pivot table.
MoveDown() Moves the field to the next position within the collection which represents the PivotTable area where this field is currently shown. Inherited from PivotFieldReferenceBase.
MoveToBeginning() Moves the field to the first position within the collection which represents the PivotTable area where this field is currently shown. Inherited from PivotFieldReferenceBase.
MoveToEnd() Moves the field to the last position within the collection which represents the PivotTable area where this field is currently shown. Inherited from PivotFieldReferenceBase.
MoveUp() Moves the field to the previous position within the collection which represents the PivotTable area where this field is currently shown. Inherited from PivotFieldReferenceBase.
ShowValuesWithCalculation(PivotShowValuesAsType, PivotField, PivotBaseItemType) Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report.
ShowValuesWithCalculation(PivotShowValuesAsType, PivotField, PivotItem) Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report.
ShowValuesWithCalculation(PivotShowValuesAsType, PivotField) Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report.
ShowValuesWithCalculation(PivotShowValuesAsType) Applies the “Show values as” calculation option to the data field to change the way summary values are displayed within the report.
ShowValuesWithoutCalculation() Shows summary values in the data field “as-is”, with no additional calculation applied to the actual value of the field.
See Also