Sums and Grand Totals Made Easier in Google Data Studio

Estimated Reading Time: 2 minutes

Google has made several updates to Data Studio’s Sums and Grand Totals features, giving users even faster, easier access to insights about their data.  The bottom line: More value from your results.

What happened, specifically?

Summary Rows are available now. Data Studio will automatically sum or average columns in a table. This is very easy to do; simply mark the “Summary Rows” option in the Table Properties.


Whether the data should be summed, averaged, etc. can be changed in the Data Source properties under “Edit Connection”.  Data Studio can auto-aggregate the data for you, particularly for formulas/calculated metrics you’ve created.



Data Studio Dashboard can be embedded in a website, blog, or internal systems. Users no longer needs to visit the Data Studio site to view the full report especially if it’s already embedded.


These tweaks to the powerful Data Studio functionality are just some of the things our consultants gleaned from the Google Analytics Summit in San Francisco recently. (See our related blog post, Leveraging Google Data Studios – Exporting Data from a Chart.)

InfoTrust is a Google Analytics Certified Partner, Google Analytics Premium Reseller and Salesforce Registered Consulting Partner.

If you’re looking for ways to leverage your data better now and in 2018, contact to learn about our consulting and custom training resources.




Last Updated: January 23, 2018

Other Articles You Will Enjoy

Get Your Assessment

Thank you! We will be in touch with your results soon.
{{ field.placeholder }}
{{ }}

Talk To Us

Talk To Us

Receive Book Updates

Fill out this form to receive email announcements about Crawl, Walk, Run: Advancing Analytics Maturity with Google Marketing Platform. This includes pre-sale dates, official publishing dates, and more.

Search InfoTrust

Leave Us A Review

Leave a review and let us know how we’re doing. Only actual clients, please.