Trying to use the query criteria to show only a single row in a batch of records with the lowest item. Something like this
So I'd like the results to show this
Tried using Dmin, but can't get that to work. Any ideas? Maybe using a helper column?
Batch | Item |
001 001 001 | 01 02 03 |
002 002 002 | 02 03 04 |
003 003 003 | 02 04 05 |
So I'd like the results to show this
Batch | Item |
001 | 01 |
002 | 02 |
003 | 02 |
Tried using Dmin, but can't get that to work. Any ideas? Maybe using a helper column?