How to show only the value for the maximum program for each country

Hi, I need your help because I would like to show in this table the program for each country which has the maximum value. Only one program (with the maximum value) for each country.

How can I do that?
With group by it does not work because I obtain the above picture but I do not obtain the maximum program for each country.

Thanks in advance

Hi @giad,

use the rank node and then filter for the ranks you want (in your case Top1)


Hi @giad,
you can first use group by to determine the max activity for each country. In a second step you join these results to your inital table using inner join method and as key columns country and activity or rather max(activity).



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.