PivotBaseItemType Enum

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v22.1.Core.dll

Declaration

C#

public enum PivotBaseItemType

VB.NET

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:

• PivotDataField.BaseItemType

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.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotBaseItemType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-spreadsheet-pivot-table-api-t314425/CS/SpreadsheetWPFPivotTableExamples/CodeExamples/ValueFieldSettingsActions.cs#L43

// Display the difference in product sales between the current quarter and the previous quarter.
dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields["Quarter"], PivotBaseItemType.Previous);
#endregion #DifferenceFrom

winforms-spreadsheet-pivot-table-api-t298650/CS/SpreadsheetPivotTableExamples/CodeExamples/ValueFieldSettingsActions.cs#L43

// Display the difference in product sales between the current quarter and the previous quarter.
dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields["Quarter"], PivotBaseItemType.Previous);
#endregion #DifferenceFrom

spreadsheet-pivot-table-api-examples-t501894/CS/SpreadsheetDocServerPivotAPI/CodeExamples/ValueFieldSettingsActions.cs#L43

// Display the difference in product sales between the current quarter and the previous quarter.
dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields["Quarter"], PivotBaseItemType.Previous);
#endregion #DifferenceFrom

VB.NET

wpf-spreadsheet-pivot-table-api-t314425/VB/SpreadsheetWPFPivotTableExamples/CodeExamples/ValueFieldSettingsActions.vb#L39

' Display the difference in product sales between the current quarter and the previous quarter.
dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields("Quarter"), PivotBaseItemType.Previous)
'            #End Region ' #DifferenceFrom

winforms-spreadsheet-pivot-table-api-t298650/VB/SpreadsheetPivotTableExamples/CodeExamples/ValueFieldSettingsActions.vb#L39

' Display the difference in product sales between the current quarter and the previous quarter.
dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields("Quarter"), PivotBaseItemType.Previous)
'            #End Region ' #DifferenceFrom

spreadsheet-pivot-table-api-examples-t501894/VB/SpreadsheetDocServerPivotAPI/CodeExamples/ValueFieldSettingsActions.vb#L43

            ' Display the difference in product sales between the current quarter and the previous quarter.
            dataField.ShowValuesWithCalculation(PivotShowValuesAsType.Difference, pivotTable.Fields("Quarter"), PivotBaseItemType.Previous)
'            #End Region ' #DifferenceFrom