Hi Friends,
I figured it out in one of my projects like this sometime ago, added these lines of javascript in the templates index file:
<script>
$(window).load(function(){
var sum = 0.0;
$('.total').each(function()
//.total is the class name for the field to sum
{
sum += parseFloat($(this).text());
});
$("#tableid").append("<tfoot><tr><td colspan='6'>Total: " + sum + "</td></tr></tfoot>");
</script>
-------------
may be it will help you.
Shubhaanshu