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