Showing 0s in pivot table for data that doesn't exist

[Brett]

Hi @glam,
Here are a couple prior posts in the community that discuss a similar scenario for your review:

Replace blank/NULL values by 0

Hi! I’m creating a WBR visual with the Receive Accuracy metric. The logic for RA metric is= POs correctly received/total POs There are some weeks where we don’t have any POs delivered in specific regions, so we have rows for that week with null values. [RA_wbr] I want to substitute those null values by ‘N/A’. I first tried to edit format data for null values, but it’s not working. Then I tried the following calculated field formula, but it gives me error and I’m not able to save it: [ra_form…

Replacing Numeric Column Blank Data With 0

PFB the screen shots of a table column data. I want to replace the blank column into zero so how can I do this? [Numeric Column]

Let us know if one of these suggested solutions work for your case or if you have any additional questions.