As of Looker 6.2, table calculations can now be applied to the totals row in your data table.
Calculations on the Totals Row Can Be Great or Confusing
As discussed in Looker documentation, table calculations calculate totals based on the single total row, not on the data column. The results are clearly understandable for some calculations, like the Orders per User table calculation's total in the following example.
However, table calculations that perform aggregations—for example calculations using `percentile` and `median`—may total in confusing ways, such as in the Mean Order Items total below.
Replacing a Totals Calculation with a Null Symbol
If you have a potentially confusing result in a table calculation total, you can replace one of your totals with a null symbol:
if(is_null(my_grouping_dim), null, <calc>)
For example, editing the Mean Order Items table calculation to this:
results in a null symbol for the total in the data table:
Related articles: For troubleshooting totals for measures, see Why don't my totals match the values in my table?