Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Summary row in the Table

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

Is there any possibility to ad somehow a summary row in the table?

 

For example:

name   Count

marina    5

anna       1

john         8

SUM      14

Summary row in the Table

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Currently not a way to add a grand totals row/column that I am aware of.

Summary row in the Table

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

Hi Marina B,

I also wanted to include a "Totals" value for each column in a report that is paginated to display 10 rows per "page", out of 98 Total rows of data.  

 

To accomplish this I used Scorecards, one for each Column I want totaled. You need to make sure the Scorecard uses the same Segments and Filters etc as the data in the Table itself. You can adjust the size of the Scorecard so the font size matches that used in the table, if you want.

 

If you are using a Date comparison, "Previous Period" for example, you can hide the Comparison Label. You can also hide the Metric name since that is shown in the Column Headers.

 

Hope this helps,

Ken

 

 

Summary row in the Table

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi Kenneth,

 

Thank you very much!

Summary row in the Table

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi! There is a setting in the chart's Table Properties pane for summary row. It iis about 2/3 down the options, try toggling that to be checked. 

Summary row in the Table

Follower ✭ ☆ ☆
# 6
Follower ✭ ☆ ☆

Thank you Sarah.  It works very well.