Hi, I want to display a table with several metrics in different columns. Alongside these I want to display 3 Dimensions. How can I display a total for each metric column within the table? I can see pivot tables allow “Totals” to be shown but it only allows 2 Dimensions. I can’t see any “Totals” opt…

Very strange behavior @Beginner Could you screenshot all the setup tab configuration please. I will try to reproduce the problem. Is the table fed by a specific data source or metric field that could provide unusual restrictions about aggregations, so total calculation? Otherwise, you should try t…

@Beginner To do so, go the “Number of rows” section of the setup tab and turn on “Show summary row”. [Mehdi_Oudjida_0-1749655420182.png] I hope it helps. Mehdi

Thanks for taking the time to read my post and reply. However for my Table, I cannot see this option. [Beginner_2-1749656422208.png] [Beginner_0-1749655937366.png]

Hi @Mehdi_Oudjida Thanks. I tried switching the table to a bar chart and then back to a table, and now the option IS appearing. As you say, very strange. But thanks for your help.

@Mehdi_Oudjida Now I found the exact reason why. When Metric Sliders are Off, you can select “Show Summary Rows” [Beginner_0-1749740907409.png] When “Metric Sliders” are on, the Show Summary Row option disappears. [Beginner_1-1749741003855.png]

Total for Metrics in a Table

Data Studio Data Studio Q&A

Beginner June 11, 2025, 3:40pm 3

Thanks for taking the time to read my post and reply.

However for my Table, I cannot see this option.

Topic		Replies	Views
Problem with table's grand total Data Studio Q&A getting-started , exploring-data , reports-and-visualizations	1	53	August 16, 2024
Table summary row incorrect Data Studio Q&A reports-and-visualizations	4	175	November 8, 2024
Pivot Table With Multiple Metrics Listed Vertically Data Studio Q&A reports-and-visualizations	1	66	February 21, 2025

Total for Metrics in a Table

AI Suggested topics