Your total does not have to appear in the same column as the rest of your data. You can place the column total in any cell of your table by using normal, spreadsheet-type cell references.