PivotBaseItemType Enum
Lists types of base items that can be used by the “Show Values As” calculation options.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Members
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. |
Related API Members
The following properties accept/return PivotBaseItemType values:
Remarks
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.