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

Summation of Metric Corresponding to Distinct values of Dimension

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a dimension A and a metric B.

I want to have a Calculated field C which does summation of B corresponding to every unique value of A.

For e.g, I have following dimension column A and metric column B.

 

 A                          B                       
601                      11                             
601                      10
601                        9
 
602                        5                      
602                        8
602                       10
 
603                        1                     
603                       11
603                        23
 
 
And i want my output column C to have values: 30 (=11+10+9) , 23 (=5+8+10) and 35(=1+11+23).
C
30
23
35
 
How to achieve the same, please suggest.