The changes in the script seem to have worked. But I am not able to understand how the changes helped to avoid the extra column with 0 in the pivot table. I am also not able to explain why there was an extra column.
Eduardo Correa, I can not change the script, bcoz calculation of shipping quantity requires some other calculations also in my case,i'm not directly using this column for expression.
Emmanuel Prieto, I've already tried "Suppress Zero-Values" option at the bottom of Presentation Tab. this will show zero values when no time period or product is selected.. but as soon as i select time axis, zero values are supressed. e.g. if for 2010 and 2011 values are 0 and 1.pivot table is:
Product Time 2010 2011 Mouse 0 1 Printer 0 1
when Printer is selected pivot table displty should be: