Any one having any idea on this ?
Here is a solution from Jim Wahl
You could also create and show a calculated field that returns a value only when the quantity is not zero.
[Sum of Sales] = IF SUM([Sales]) <> 0 THEN SUM([Sales]) END
I tend to prefer Jim's solution. The calculated field option would show that there are null values in your data which is not accurate.