Grand total at SQL

Hi community! Me again! there is any chance to get on a SQL, a last row that provides the Grand Total for all the numeric columns?.

I know the Pivot table let do this, but we need it on the SQL results. Thanks in advance!

Hello ! looked at the side of the count() function in SQL!

Hi Anthony! Thanks, but the issue is that I have already different counts and/or sums from different tables at the same SQL and does not work... :frowning:

Hi @albertogc
You can use a SQL question as the base via Saved Questions, so you can use Pivot Table: https://www.metabase.com/docs/latest/questions/sharing/visualizing-results#pivot-table

If you want to do it all in SQL, then you'll have to adjust the query, so it adds a grand total. How to do that depends on your database type. Example https://stackoverflow.com/questions/17934318/add-a-summary-row-with-totals