I want to add the total field(calculates sum of each column) below the datatable ,How can I do that?

varunm

Hi

AcName SaleCount TerminalCount TotalRetail
XYZ 1 3 13.98
PQR 2 5 43.98
JKY 1 7 93.98
TOTALS 4 15 151.95

As you can see the above datatable .Here is the row with the name "TOTALS" which calculates the sum of each column(Sale Count,terminalCount etc).How Can I create this row (TOTALS) using datatable.This row must lie below the div of Datatable(Div means the whole row and column except TOTALS row,Totals row must lie outside the Datatable region

Waiting for your response!!

Varun