Need to get the only 1st order!

[YA]

Hi. I need to get only the 1st order from each customer.

Here is the situation:

The report needs to show each customer with his/her 1st order. However, lots of customers have placed multiple orders already so (I think) I need to put a formula to exclude the orders but the 1st order...The order table has "Order Created On" date field and "Order Number" field that is generated by the database automatically (the lower the earlier).

Is there any way I can select only the 1st order by making good use of these fields?

Any idea will be appriciated!! Thanks!

 

[BFAGG]

try using the NthSmallest function eg;

NthSmallest({Order Number,1) the ',1' returns the smallest. NthSmallest({Order Number,2) would return second smallest etc;

 

[YA]

Thanks BFAGG!

I ended up using the function like this:
NthSmallest(1, {Order_Number}, group)

It returns the smallest order number for each group.
Thanks again!