PivotDataField Methods

Represents a reference to a PivotField object that is currently shown as a 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.