Office script-Pivot table-Pivot table options

Question

I have created a pivot table on an excel table using office script. but in pivot table few cells are blank or null i want them to be replaceed with zero.

just like manually we do in pivot table options-Layout and format-for eampty cells show -0

i want this to bve done via office script .

eg. here forth row More than 7 Days is blank it show show 0

Pending score AO Kolhapur
Count of REF_NUM	Column Labels
Row Labels	Less than 8 Days	More than 7 Days	Grand Total
RBO SOLAPUR	15		15
ICHALKARANJI	5	8	13

Answer 1

I'd suggest you create a new thread on Office Development which is special channel to handle Office script questions.

Office Development - Microsoft Q&A

Thank you for your understanding.