add numeric columns

[tiverson]

I have a table that sums an account balance by company.  I want to add a grand total column, but I need it to be dynamic since there may be more (or less) companies added in the future.

Current Data

What formula can I use that will make the addition fluid and change whenever companies are added or removed?

Desired Output

[DataNath]

I believe this should work? Let us know if not! Had to trim off the original grand totals to regenerate them within.

[Qiu · Accepted solution]

@tiverson 
There is an option "Total Column" in the Cross Tab. so we can do a Transpose then Cross Tab back the data as below.
This is absolutely dynamic😁

[DataNath]

Oh boy, how did I miss that @Qiu? 😂

Every day is a school day!

[Qiu]

@DataNath 
Being the similar situation many times. 🤣