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.
... View more
