There will be a "totals" line in the Spreadsheet and Query macros, where users will be able to specify:
Calculation, in SQL, such as " SUM(PRICE)"
and the spanning, so several totals are available.
They will be aligned to the right.
As a user, I expect to perform calculations simply.