Hello everyone,
I want to ask you a question about a subject that I have been dealing with a lot.
I have a table like this:
segment | group | date | actual |
A | a | Jun-21 | 3 |
A | a | Jun-21 | 5 |
A | b | Jul-21 | 7 |
A | c | Aug-21 | 8 |
B | e | Sep-21 | 4 |
B | e | Sep-21 | 6 |
C | d | Nov-21 | 2 |
C | d | Nov-21 | 5 |
C | f | Jan-22 | 7 |
I want to sum actual values of same segment,same group, same date like this:
segment | group | date | actual |
A | a | Jun-21 | 8 |
A | b | Jul-21 | 7 |
A | c | Aug-21 | 8 |
B | e | Sep-21 | 10 |
C | d | Nov-21 | 7 |
C | f | Jan-22 | 7 |
How can I do that in Data Studio(Prepare Data). I couldn't do this with any transform option and also "code" option in "custom transform" options.
I would be very grateful if someone could help.
Thanks.