Excel.ShowAsCalculation enum

包:
excel

DataPivotField 的 ShowAs 计算函数。

注解

API 集：ExcelApi 1.8

使用方

示例

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/38-pivottable/pivottable-calculations.yaml

await Excel.run(async (context) => {
    const pivotTable = context.workbook.worksheets.getActiveWorksheet().pivotTables.getItem("Farm Sales");
    const farmDataHierarchy: Excel.DataPivotHierarchy = pivotTable.dataHierarchies.getItem("Sum of Crates Sold at Farm");        
    const wholesaleDataHierarchy: Excel.DataPivotHierarchy = pivotTable.dataHierarchies.getItem("Sum of Crates Sold Wholesale");

    farmDataHierarchy.load("showAs");
    wholesaleDataHierarchy.load("showAs");
    await context.sync();

    // Show the crates of each fruit type sold at the farm as a percentage of the column's total.
    let farmShowAs = farmDataHierarchy.showAs;
    farmShowAs.calculation = Excel.ShowAsCalculation.percentOfColumnTotal;
    farmShowAs.baseField = pivotTable.rowHierarchies.getItem("Type").fields.getItem("Type");
    farmDataHierarchy.showAs = farmShowAs;

    let wholesaleShowAs = wholesaleDataHierarchy.showAs;
    wholesaleShowAs.calculation = Excel.ShowAsCalculation.percentOfColumnTotal;
    wholesaleShowAs.baseField = pivotTable.rowHierarchies.getItem("Type").fields.getItem("Type");
    wholesaleDataHierarchy.showAs = wholesaleShowAs;
    await context.sync();
});

字段

differenceFrom = "DifferenceFrom"

与指定的基本字段和基本项的差异。
index = "Index"

按如下方式计算值 ( (：单元格) 中的值 x 总计总 (总计) ) / 总行汇总 ( () x 总列总计) ) (
none = "None"

不应用任何计算。
percentDifferenceFrom = "PercentDifferenceFrom"

与指定的基本字段和基本项的差异。
percentOf = "PercentOf"

指定的“基本”字段和“基本项”的百分比。
percentOfColumnTotal = "PercentOfColumnTotal"

列总和的百分比。
percentOfGrandTotal = "PercentOfGrandTotal"

总计的百分比。
percentOfParentColumnTotal = "PercentOfParentColumnTotal"

指定“基本”字段的列加百分比。
percentOfParentRowTotal = "PercentOfParentRowTotal"

指定“基本”字段的行汇总百分比。
percentOfParentTotal = "PercentOfParentTotal"

指定“基本”字段总计的百分比。
percentOfRowTotal = "PercentOfRowTotal"

行汇总百分比。
percentRunningTotal = "PercentRunningTotal"

指定“基”字段的汇总百分比。
rankAscending = "RankAscending"

指定“基本”字段的升序排名。
rankDecending = "RankDecending"

指定“基本”字段的降序排名。
runningTotal = "RunningTotal"

指定的“基”字段的汇总。
unknown = "Unknown"

计算未知或不受支持。