How to display total sum of a column of ALL the records in the footer?

If you need to set total sum for all records, you would need to set page size to a very large number 

$dg->set_pagesize('100000');

- Or -

Use vertical scroll feature. 

$dg->set_scroll(true);

Feedback and Knowledge Base