Edit

Excel.ShowAsCalculation enum

Package:
excel

The ShowAs calculation function for the DataPivotField.

Remarks

[Api set: ExcelApi 1.8]

Fields

differenceFrom = "DifferenceFrom"

Difference from the specified Base field and Base item.

  • [Api set: ExcelApi 1.8]
index = "Index"

Calculates the values as follows: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

  • [Api set: ExcelApi 1.8]
none = "None"

No calculation is applied.

  • [Api set: ExcelApi 1.8]
percentDifferenceFrom = "PercentDifferenceFrom"

Difference from the specified Base field and Base item.

  • [Api set: ExcelApi 1.8]
percentOf = "PercentOf"

Percent of the specified Base field and Base item.

  • [Api set: ExcelApi 1.8]
percentOfColumnTotal = "PercentOfColumnTotal"

Percent of the column total.

  • [Api set: ExcelApi 1.8]
percentOfGrandTotal = "PercentOfGrandTotal"

Percent of the grand total.

  • [Api set: ExcelApi 1.8]
percentOfParentColumnTotal = "PercentOfParentColumnTotal"

Percent of the column total for the specified Base field.

  • [Api set: ExcelApi 1.8]
percentOfParentRowTotal = "PercentOfParentRowTotal"

Percent of the row total for the specified Base field.

  • [Api set: ExcelApi 1.8]
percentOfParentTotal = "PercentOfParentTotal"

Percent of the grand total for the specified Base field.

  • [Api set: ExcelApi 1.8]
percentOfRowTotal = "PercentOfRowTotal"

Percent of the row total.

  • [Api set: ExcelApi 1.8]
percentRunningTotal = "PercentRunningTotal"

Percent running total of the specified Base field.

  • [Api set: ExcelApi 1.8]
rankAscending = "RankAscending"

Ascending rank of the specified Base field.

  • [Api set: ExcelApi 1.8]
rankDecending = "RankDecending"

Descending rank of the specified Base field.

  • [Api set: ExcelApi 1.8]
runningTotal = "RunningTotal"

Running total of the specified Base field.

  • [Api set: ExcelApi 1.8]
unknown = "Unknown"

Calculation is unknown or unsupported.

  • [Api set: ExcelApi 1.8]