Sum combined with firstsortedvalue

[#1]

Hi all,

I have the need to use the sum aggregation filtered by a set analysis expression that contains a firstsortedvalue expression.

For example, I have the following data:

F1	F2	F3	F4
A	pippo	2	1
A	pippo	3	1
A	pluto	4	2
A	pap	6	3
B	cip	2	4
B	paperone	4	6
B	pippo	7	4
B	pluto	11	5
C	pippo	1	8
C	minni	3	6
C	pluto	4	7
C		5	2
C	ciop	5	5

I have a table which contains the first value of F2 order by F4, like below:

F_agg	=if(F_agg='Other',null(), F1)	FirstSortedValue({$<F2-={""},F_agg={'Best'}>}distinct F2,F4)
Best	A	pippo
	B	pippo
	C	ciop

Now my issue is to get in a new column the sum(F3) only for the value of F2 return by firstsortedvalue.

I try with set analysis but without results.

Any idea?

Thanks in advance,

Davide