How to prevent displaying zeros in pivot table?

[nburaq]

Hi,
I encountered strange behavior in pivot chart. If my source table for pivot chart includes formula, then the calculation in pivot chart shows zero, though there is no data in cells formulated. Is there any way to prevent this?
Thanks for your help and concern.

formula from Jan to Dec

 

[arthurbr]

Perhaps How to Remove Blanks in a Pivot Table in Excel (6 Ways) | Avantix Learning