Sheet Summary Report Grand total row ?

I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows

The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet.


Miami $138,875

Tampa $264

My question is how can i get a grand total row which shows the total of both Miami and Tampa for $139,139,?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!