Thanks Anton,

I have used your input, and added additional html tags to suit my 
requirement like below.

<tr><td colspan="3">Total</td><td align="right"><xsl:value-of 
select="format-number(sum(/xml/rs:data/z:row/@qty),'#.0000')"/></td><td></td>

Thanks once again
Regards
Eugene