Dynamic Totals after Load To

[OldCityCat]

Does any one know a way to add a total row and sum the same 1 or 2 columns after query has run and loaded?

Thanks in advance for any and all suggestions

OldCityCat

 

[AliGW]

What do you mean by "the same 1 or 2 columns"? You can add a totals line to the table - it should stay intact when you refresh the query and update.

 

[Ken Puls]

I would agree with Ali here. Load the table to the worksheet, go to the Table Design tab and in the Table Style options group, check the "Total Row" box.

Personally, I'd rather leave the output without totals, then feed that to a PivotTable as it's fully dynamic for new data at that point anyway.