Skip to main content

Chat Now

Buy Support Center Documentation Training Free Trial

Download CHM

PivotDataField Members

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

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.

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

PivotDataField Interface

DevExpress.Spreadsheet Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.