Hi Shin, Thanks for the quick response. My requirement is something different.
For some reasons i have separated each year with the help of calculated field 2011,2012,2013 and 2014. How to show nulls when there is no values were each year is acting as a separate column.
Null.twbx 1.2 MB
I'm sorry I don't understand the request correctly.
In my example, Null is already shown as "0" as you mentioned at original post. // i what to show it as 0's. ///
What is the new request?
Or if you can attach packaged workbook with detail explanation, it may be easier.