Table of Contents
Overview
This Custom Field returns the value of a given field for the first record in a group.
Syntax
GROUPFIRST(‘GroupPath‘,’SortField‘,’FieldValue‘)
| Element | Description |
|---|---|
| GroupPath | Group path, delimited by colons. |
| SortField | The field to sort the records in the group by. |
| FieldValue | The field that to retrieve the value from. |
Example
GROUPFIRST(‘Parent Category:Child Category‘,’Price‘, ‘Colour‘)
This command will first sort the ‘Price’ field into ascending ‘Price’ order and return the first associated colour Red.
| Colour | Price |
| Yellow | 12.80 |
| Red | 11.00 |
| Blue | 17.79 |
See also