Am I crazy or is this really not possible in Google Data Studio?
I want to sum the grand total row into one number. How do I achieve this?
Screenshot to illustrate the problem
Edit: I extract Google Analytics Goals Completions into a table in Google Data Studio. The table looks like this
| Metric | Goal 1 | Goal 2 | Goal 3 |
|---|---|---|---|
| First metric | 10 | 12 | 13 |
| Second metric | 12 | 15 | 20 |
| Grand total (Summary row) | 22 | 27 | 33 |
Grand total row is calculated by Data Studio by checking the checkbox - Summary row.
Now, I want to sum the grand total numbers into one number. So maybe in another row like this
| Metric | Goal 1 | Goal 2 | Goal 3 | Sum |
|---|---|---|---|---|
| First metric | 10 | 12 | 13 | 35 |
| Second metric | 12 | 15 | 20 | 47 |
| Grand total (Summary row) | 22 | 27 | 33 | 82 |
I can't seem to find a way how to do it.
Here is a minimal reproducible example in Data Studio
Unfortunately I can't provide my attempts because I just don't have any. I'm seriously baffled by this, I would expect it would be more intuitive.
In excel I would just SUM() the numbers to get one number I want.