Skip to main content
Row

PivotDataField Properties

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.
See Also