display the line with min (Sales)

[zied_ahmed1]

Hello I have this code and I want to display in a table object only the row with the minimum sales via a flag 

Table1:
Load * Inline [
Risque_id,Nom,Sales
1,Ahmed,100
2,Taxi,200
3,Hendo,300];

right join

Table2:
Load * Inline [
Risque_id,Country,agee,Language,date_birthday,agee_min

1,USA,77,English,03/04/2000,77
3,France ,99,French,05/07/2017,99

];

left Join (Table3)
Load
Distinct
Risque_id,
Min(Sales),

1 as flagmin

resident Table1
Group by Risque_id;

 Thanks for help 

[Anil_Babu_Samineni]

Something like this?

Sum({<flagmin={1}>} Sales)

[zied_ahmed1]

Hello with this code for the flag will display only 1 

[zied_ahmed1 · Accepted solution]

this is simply the solution 

left Join (Table_final)
Load
Distinct

min (Sales) as Sales,

1 as flagmin

resident Table_final;