function which returns all values of a particular field

[Anonymous]

Hi,

I need a function which returns all values of a particular field. Is it possible?

If I use GetFieldSelections it returns only those values that have been selected.

Thank you in advance,

Larisa

[marcus_sommer]

You could use concat({1} distinct Field, ',').

- Marcus

[swuehl · Accepted solution]

That returns all possible values:

=CONCAT(DISTINCT Field, ', ')

or all values that are in the data model:

=CONCAT({1} DISTINCT Field, ', ')