Hello Avinash I tried the same, but it does not work in my case. In my dv, I am showing the no of orders for different product divisions by customers. So if a certain cutsomer does not have any order for a one of the product divisions, it will have null for that, however the other product divisions have value. The issue is…

Hi Gabby Thanks for your reply. Could you please elaborate how to use a calc here? I guess the idea would be cast the concerned value column in this data format: #,##0;-#,##0;0 I am not sure how to though. Appreciate your help.