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)
Usage
Dim xlPivotFieldCalculation1 As XlPivotFieldCalculation = XlPivotFieldCalculation.xlDifferenceFrom
Syntax
Public Enum XlPivotFieldCalculation
public enum XlPivotFieldCalculation
public enum class XlPivotFieldCalculation
public enum XlPivotFieldCalculation
public enum XlPivotFieldCalculation
Members
| Member name | Description |
|---|---|
| xlDifferenceFrom | The difference from the value of the Base item in the Base field. |
| xlIndex | Data calculated as ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total)) |
| xlNoAdditionalCalculation | No calculation. |
| xlPercentDifferenceFrom | Percentage difference from the value of the Base item in the Base field. |
| xlPercentOf | Percentage of the value of the Base item in the Base field. |
| xlPercentOfColumn | Percentage of the total for the column or series. |
| xlPercentOfRow | Percentage of the total for the row or category. |
| xlPercentOfTotal | Percentage of the grand total of all the data or data points in the report. |
| xlRunningTotal | Data for successive items in the Base field as a running total. |
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000