Here is one way to solve the problem; I created a formula that whenever a new value of Lot is found, it calculates when the first occurrence of Lot appeared.
![txnelson_0-1680811887335.png txnelson_0-1680811887335.png](https://community.jmp.com/t5/image/serverpage/image-id/51788i8125A1183620454B/image-size/medium?v=v2&px=400)
If( :Lot != Lag( :Lot ),
currLot = :Lot;
begin = :Box[Min( Current Data Table() << get rows where( :Lot == currLot ) )];
);
begin;
If you want to iterate in open code, the following code can be used
For Each Row(
If( :Lot != Lag( :Lot ),
currLot = :Lot;
begin = :Box[Min( Current Data Table() << get rows where( :Lot == currLot ) )];
);
Show( begin );
);
Jim