Share via

Office script-Pivot table-Pivot table options

Anonymous
2024-09-26T10:11:16+00:00

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
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2024-09-26T14:44:57+00:00

    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.

    Was this answer helpful?

    0 comments No comments