GROUPFIRST

Syntax

GROUPFIRST(<any>; order by any)

Description

This function returns a value in a group as specified by the ordered column's first value.

• If the column used to order the group is a number, then the value used from the order column is the lowest number.
• If the column used to order the group is a string, then the value used from the order column is the lowest number (in string form). If no numbers (in string form) are present, the first capital letter alphabetically is used. If no uppercase letters are present, the first lowercase letter alphabetically is used.
• If the column used to order the group is a date, then the value used from the order column is the earliest date.

This is an aggregate function. 

Example

Given the following raw data:

Create a group, using GROUPBY(#RawData!Customer_number), and GROUPBY(#RawData!Name).

Using GROUPFIRST(#RawData!Item;#RawData!Order_number), you can return the first item ordered by each customer.