ListAgg
Joins the values in a column into a single value. Each window of values within a column will be combined into a single list of values.
Usage
ListAgg(column, separator )
column (required) The column of values that you would like to combine.
separator (optional) The separator to use between values. If no separator is specified, a comma will be used.
Example
ListAgg([Account Owners], "-")
- In each group, values from the column Account Owners will be combined and listed in a single row, separated by a dash.