sas data studio aggregation(sum) function

[ggunes]

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.

[EyalGonen]

Hi @ggunes 

I am not a Data Studio expert but my guess is if no built-in transform allows it, then you can always fallback to using the "custom code" node with CASL language and summarize the data like shown here: https://blogs.sas.com/content/sgf/2019/08/08/summarization-in-casl/ 

Eyal