set analysis help

[#1]

Hello,

i have a simple tab:

CT	Concorrente	ListinoR	OE?	PRIOR	ListinoCOM
00751	M	21,01	O	2	13,43
00751	N	21,01	O	1	21,44
00751	T	21,01	O	1	17,25
00751	V	21,01	O	2	23,16
01570	M	25	O	3	45,00

I need to identify the lowest "ListinoCOM" with the lower PRIOR value for each CT, and sum them.

In this case, i should sum 17,25 and 45

Can someone help me please?

Thank you!

[#2]

Try with the nummin function.

By Rebeca

[Gysbert_Wassenaar · Accepted solution]

Try min({<PRIOR={"=PRIOR=aggr(nodistinct min(PRIOR),CT)"}>}ListinoCOM). See attached example

[#4]

Thank you! It works