Skip to main content
Row

PivotDataField Members

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

Properties

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

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