当试图使用Office脚本从数据集自动化我的数据透视表时，脚本一直说“let pivotTable = newSheet.addPivotTable（“mypivot”，table，“A1”）;“

function main(workbook: ExcelScript.Workbook) {
// Create a PivotTable based on a table in the current worksheet.
let sheet = workbook.getActiveWorksheet();
let table = sheet.getTables()[0];

// Add the PivotTable to a new worksheet.
let newSheet = workbook.addWorksheet("Holtersum");
let pivotTable = newSheet.addPivotTable("mypivot", table, "A1");

// Add fields to the PivotTable to show "Sales" per "Type".
pivotTable.addRowHierarchy(pivotTable.getHierarchy("Operator Name"));
pivotTable.addDataHierarchy(pivotTable.getHierarchy("Holter"));

}
我希望使用两列中的值创建透视表