# last()

Returns the last value in the tuple for the specified field.

Use `last()` to return the last value of a measure or dimension. You can also use `last()` to return the value of a field without grouping by that field.

:::note
If the values are not sorted, the 'last' value could be any value in the tuple.
:::

## Example - Return the Last Industry for an Account Owner

Your reps own opportunities in several industries. You need a list of rep names with their last industry, where industry is sorted alphabetically. Group by account owner and industry, sort by industry, then use `first()` to get the last industry.

```nolang
q = load "DTC_Opportunity_SAMPLE";
q = group q by ('Account_Owner', 'Industry');
q = foreach q generate 'Account_Owner' as 'Account_Owner', 'Industry' as 'Industry';
q = order q by 'Industry';

q = foreach q generate 'Account_Owner' as 'Account_Owner', last('Industry') as 'One Industry';
```

![Diagram showing first function with sorted field.](https://a.sfdcstatic.com/developer-website/sfdocs/analytics/media/bi_dev_guide_saql/bi_saql_fn_agg_last_image.png)

**See Also**

- [first()](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-1st.md)