We are currently using the table visualization in Metabase (not the pivot table) and would like to add a total row at the bottom. However, we need the ability to customize how totals are calculated for each column.
For example, some columns should display a simple sum of the field, while others (especially percentage-based columns) require a formula like SUM(A) / SUM(B) . Applying SUM(A / B) directly does not yield the correct result.Is there a way to implement a total row with custom formulas per column?
Adding subtotals to a table is currently only supported in Pivot Table visualizations.
As a workaround, you could add an extra row to the query with SQL UNION ALL, and within that extra row, you can calculate the totals you need for each column.
PD: there's an open feature request for subtotals, make sure to give it a thumbs up!
