Last
Returns the last row value in a column.
Usage
Last([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
Last([Quarter])
Returns the last result in the [Quarter] column in every row of the [Last] column.