Normally, the Pivot Table displays null and zero as empty cells. To show the null or zero as custom value in the Pivot Table, you should provide provision.
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
(Last updated on: June 24, 2019).