First
Returns the first row value of a column.
Usage
First([column])
Function Arguments:
- field (required) A column of text, numbers, or dates to analyze.
When there is no sort specified to the table, the results for this function can change when refreshing the workbook, as the sort will be different upon refresh.
Example
First([Quarter])
- Returns the first result in the [Quarter] column in every row of the [First] column.