Excel.ShowAsCalculation enum

数据透视字段的 ShowAs 计算函数。The ShowAs Calculation function for the Data Pivot Field.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

字段

differenceFrom = "DifferenceFrom"

与指定的基本字段和基本项之间的差异。Difference from the specified Base Field and Base Item.

index = "Index"

计算值, 如下所示: ((单元格的值) x (总计总计))/((总计行总计) x (总计列总计))Calculates the values as follows: ((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

none = "None"

不应用任何计算。No calculation is applied.

percentDifferenceFrom = "PercentDifferenceFrom"

与指定的基本字段和基本项之间的差异。Difference from the specified Base Field and Base Item.

percentOf = "PercentOf"

指定的基本字段和基本项的百分比。Percent of the specified Base Field and Base Item.

percentOfColumnTotal = "PercentOfColumnTotal"

列总计的百分比。Percent of the column total.

percentOfGrandTotal = "PercentOfGrandTotal"

总计的百分比。Percent of the grand total.

percentOfParentColumnTotal = "PercentOfParentColumnTotal"

指定基本字段的列总计的百分比。Percent of the column total for the specified Base Field.

percentOfParentRowTotal = "PercentOfParentRowTotal"

指定基本字段的行总计的百分比。Percent of the row total for the specified Base Field.

percentOfParentTotal = "PercentOfParentTotal"

指定基本字段的总计的百分比。Percent of the grand total for the specified Base Field.

percentOfRowTotal = "PercentOfRowTotal"

行总计的百分比。Percent of the row total.

percentRunningTotal = "PercentRunningTotal"

指定基本字段的运行百分比总计。Percent Running Total of the specified Base Field.

rankAscending = "RankAscending"

指定的基本字段的升序排名。Ascending Rank of the specified Base Field.

rankDecending = "RankDecending"

指定的基本字段的降序排名。Descending Rank of the specified Base Field.

runningTotal = "RunningTotal"

指定的基本字段的运行总计。Running Total of the specified Base Field.

unknown = "Unknown"

计算未知或不受支持。Calculation is unknown or unsupported.