Hello Team. I am trying to format a pivot table value field well which currently shows empty for some cells and want to replace these with a custom value. Please refer to the image below. The third row currently shows empty and ideally want to replace that with 0%. [image]

Hi, you can solve this with a calculated field and use coalesce(value,0).

Formatting empty value cell in pivots

Hassain April 20, 2023, 11:44am 7

Do we have any update on the feature ?

Filling missing value with 0 in pivot table