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.

e.g.

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,?

Find more posts tagged with

Sheets

Formulas

Reports

functionality

Comments

Andrée Starå

Hi Tony,

Unfortunately, it's not possible at the moment to sum a Sheet Summary Report, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tony Conaghan

Thanks for your help Can you suggest a possible workaround that i can achieve a consolidated report of the 2 sheets revenue ? I can not consolidate the 2 sheets into 1 for security reasons

Andrée Starå

Happy to help!

Would it work to collect the values from one of the sheets to the other?

Tony Conaghan

Thanks Andree

Unfortunately not

Only Miami is allowed to see Miami and Tampa to see Tampa .

Only the Southeast Manager can see both and wants summed totals for those 2 and 8 other cities combined

Andrée Starå

Ok.

We can still collect the values without them actually seeing the values except the total.

If not, I would recommend a Master Metric Sheet and structure it so it's secure.

Would that work?

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.