Hi,
I have tried creating a Table visualization with subtotals enabled. While the subtotals are shown, but the values are not right.
Not sure why subtotals could go wrong, because the underlying data seems to be good.
If you underlying table has more rows than the data limit (max 5k rows) Looker will 'leave information behind' not showing all the values.
https://cloud.google.com/looker/docs/table-options#subtotals