i am using %of in pivot table, but it is showing #DIV/0! as this image.

http://www.foxite.com/uploads/df354788-9eca-4440-b868-d126c1c6e82d.jpg

how to solve this

** code for %of
oChangeField=oPivotTable.AddDataField(oPivotTable.PivotFields("netamt"), "avg_sales")
oChangeField.Calculation= 3  && xlPercentOf
oChangeField.BaseField="yearname"
oChangeField.BaseItem="(previous)"

Warm Regards,
mk.