I’m using Office Script to generate a pivot table and for summarize using following script where Due is in the format of h:mm
pivotTable.addDataHierarchy(pivotTable.getHierarchy(“Due”)).setSummarizeBy(ExcelScript.AggregationFunction.sum)
It is throwing error as missing argument or invalid argument
I want to summarize the Due column in pivot table which is in the format of h:mm
New contributor
Monika is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.