Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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

public enum PivotBaseItemType

#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.

See Also