How to Add a Totals Row to an Excel Table Refreshed from SQL Server

Prev Next

How to Add a Totals Row to an Excel Table Synced with SQL Server

SQL Spreads clears all data below the Excel table when the data is refreshed from the SQL Server table. This will have the effect that summary rows will also be deleted.

To add a Totals row, we recommend that you add a section above the Excel table and add your Total rows there:
image.png

When you add your summary formula, reference the data using an Excel table column reference as in the example below:
image.png

You can copy the formula from here:

=SUBTOTAL(9;Table2[Amount])