XlPivotFieldCalculation Enumeration
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

XlPivotFieldCalculation Enumeration

Specifies the type of calculation performed by a data PivotField when a custom calculation is used.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlPivotFieldCalculation

Member nameDescription
xlDifferenceFromThe difference from the value of the Base item in the Base field.
xlIndexData calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))
xlNoAdditionalCalculationNo calculation.
xlPercentDifferenceFromPercentage difference from the value of the Base item in the Base field.
xlPercentOfPercentage of the value of the Base item in the Base field.
xlPercentOfColumnPercentage of the total for the column or series.
xlPercentOfRowPercentage of the total for the row or category.
xlPercentOfTotalPercentage of the grand total of all the data or data points in the report.
xlRunningTotalData for successive items in the Base field as a running total.
xlPercentOfParentRowPercentage of the total of the parent row.
xlPercentOfParentColumnPercentage of the total of the parent column.
xlPercentOfParentPercentage of the total of the specified parent Base field.
xlPercentRunningTotalPercentatge of the running total of the specified Base field.
xlRankAscendingRank smallest to largest.
xlRankDecendingRank largest to smallest.
Show:
© 2016 Microsoft