Find Min value and retrieve other field in same record

[#1]

I have the table chart like this:

Producto	Supplier	Min(Amount)
A	1	574
A	2	1504
A	3	897
B	1	175
B	2	64
B	3	398
C	1	2248
C	2	467
C	3	302

I tried to use the FirstSortedValue to get the supplier have the min amount in each Producto, but it didn't work: =FirstSortedValue(Supplier, Aggr(DISTINCT Min(Amount), Producto))

The expected output:

Producto	Supplier	Product MinAmount
A	1	574
B	2	64
C	3	302

[kumarnatarajan · Accepted solution]

Hi,

PFA.

[tresesco]

PFA

[#4]

Thanks Kumar and tresesco!