XlPivotFieldCalculation enumeration
Office 2013 and later
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)
| 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. | |
| xlPercentOfParentRow | Percentage of the total of the parent row. | |
| xlPercentOfParentColumn | Percentage of the total of the parent column. | |
| xlPercentOfParent | Percentage of the total of the specified parent Base field. | |
| xlPercentRunningTotal | Percentatge of the running total of the specified Base field. | |
| xlRankAscending | Rank smallest to largest. | |
| xlRankDecending | Rank largest to smallest. |
Show: