PivotBaseItemType Enum

Lists types of base items that can be used by the “Show Values As” calculation options.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp

public enum PivotBaseItemType

Public Enum PivotBaseItemType

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.

The following properties accept/return PivotBaseItemType values:

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.