I was wondering if anyone has been able to display totals in a Table/Pivot visualization? Similar to what is possible in other BI tools?

If I have a table with a bunch of rows and one of the columns is Total Cost, I want to be able to show a Total at the end of the table which sums the total cost of the column. Would also like for the Total to be flexible and always displayed.

If possible would like to avoid calculating the Total in a SQL query, any ideas