Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
PFA.
PFA
Thanks Kumar and tresesco!