Why are my totals not showing up? (Community)

View the original community article here

Last tested: June 2020

1. 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".

2. 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.