A summary of your data is always useful. You can add column totals to your report by clicking the Totals checkbox in the upper right of your results tab, then running the report on your Explore page.
Getting the Totals when using table calculations is now possible, as of 6.2 Looker release.
However, some table calculations that perform aggregations, such as calculations using percentile or median, might not add up as you expect. This is because table calculations calculate totals using the values in the total row of your Explore page, not using the values in the data column.
This means table calculations are only performed by using the data displayed on your Explore page. It is possible to calculate totals only for the data you can see. To do so, you can use a table calculation formula like:
- For a column total use
sum(${view_name.field_name}). - For a row total use
sum(pivot_row(${view_name.field_name}))