Last tested: June 2020
-
Totals only apply to measures. They won't appear on dimensions, or on table calcs prior to Looker 6.2 (See this Community post: Why don't my table calculations have totals). This is because to run a total, we remove the dimensions and re-run the query, so that any measures are "totaled".
-
If the totals are not showing up for measures either, it may be because a measure filter is filtering out the totals results. The HAVING clause that a measure filter generates for the main query is also generated for the totals query, so the totals row won't show up if the results don't meet the HAVING condition.
This content is subject to limited support.