officefileapi-devexpress-dot-spreadsheet-dot-pivotdatafield-1459bd48.md
Returns the type of the base item used by the “Show Values As” calculation option applied to the data field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
PivotBaseItemType BaseItemType { get; }
ReadOnly Property BaseItemType As PivotBaseItemType
| Type | Description |
|---|---|
| PivotBaseItemType |
A PivotBaseItemType object that specifies the base item type.
|
Available values:
| Name | Description |
|---|---|
| Specified |
Indicates that the value of a specific item is used for a custom calculation.
| | Previous |
Specifies that the value of the previous item is used to calculate the value of the current item in the PivotDataField.BaseField.
| | Next |
Specifies that the value of the next item is used to calculate the value of the current item in the PivotDataField.BaseField.
|
To obtain a base field and base item used by a custom calculation option applied to the data field, use the PivotDataField.BaseField and PivotDataField.BaseItem properties, respectively.
See Also