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
Solved! Go to 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
Being the similar situation many times. 🤣