You can't do this with standard DBGrid and I don't know any third party components which can do this (other then just putting a label below the DBGrid with the total).
But can't you change your SQL-statement to include a summary-record? In some SQL-variants you can use ROLLUP. If your DB doesn't support that you could use UNION ALL and do a SELECT with SUM in the second part.