2

In Google Data Studio I have a small table including a dimension and a metric

Channel User
A 1.000
B 2.500
C 500

Is there a way to calculate the total sum across the dimension (like an LOD) which is shown as an additional column next to the user? The solution should look like this

Channel User Total Users
A 1.000 4.000
B 2.500 4.000
C 500 4.000
fjetsche
  • 45
  • 1
  • 7

2 Answers2

4

It can be achieved by using a self Data Blend

1) Data Blending

Data Source 1

  • Dimension: Channel
  • Metric: Users

Data Source 2

  • Metric: Users; Rename to Total Users

2) Table

  • Data Source: Blended Data Source
  • Dimension: Channel
  • Metric 1: Users
  • Metric 2: Total Users

Editable Google Data Studio Report and a GIF to elaborate:

Nimantha
  • 6,405
  • 6
  • 28
  • 69
0

You can either compute your new variable Total Users in your data, before importing in GDS.

Otherwise do a self join (cfr other reply)

Or you can have a running total, which will have the final sum only in the last row. enter image description here

stallingOne
  • 3,633
  • 3
  • 41
  • 63