officefileapi-devexpress-dot-spreadsheet-dot-pivotdatafield-dot-underscore-members.md
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