Total over all pages

Hi,
you can add total for the current page on the Fields order and totals tab.
To show total for all pages (for whole table) use ListOnLoad event on the Events tab.

Here is a sample code:

global $conn;

$from=stristr ($strSQL," from ");

$order=strrpos($from," order by");

if($order)

$from=substr($from,0,$order);

$sql = "select sum(FieldName) ".$from;

$rs=db_query($sql,$conn);

$data=db_fetch_numarray($rs);

echo $data[0];

where FieldName is your actual field name.