Lists types of base items that can be used by the "Show Values As" calculation options.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.2.Core.dll
| Name | Description |
|---|---|
| Next | Specifies that the value of the next item is used to calculate the value of the current item in the PivotDataField.BaseField. |
| Previous | Specifies that the value of the previous item is used to calculate the value of the current item in the PivotDataField.BaseField. |
| Specified | Indicates that the value of a specific item is used for a custom calculation. |
To use the value of the previous or next item in the PivotDataField.BaseField for a custom calculation, pass the corresponding PivotBaseItemType enumeration value to the PivotDataField.ShowValuesWithCalculation method as a parameter. To use a specific item for a custom calculation, call the PivotDataField.ShowValuesWithCalculation method overload that accepts a PivotItem object as a parameter.
To obtain the type of the base item used for a custom calculation, use the PivotDataField.BaseItemType property.