How to get common activities from a list

I have a table. Inside that table, I have another table in the line definition. In the inner table, I have a field that is connected to activity names. Right now, the inner table shows all the activity names in the record set, even if the same activity names are in there multiple times. However, I do not want duplicate activity names to show.

For example: If the list consisted of the following activity names,

running
walking
jumping
running
skating
skating
biking
biking
biking

Then I would like the table to only show the following

running
walking
jumping
skating
biking

How can I go about doing this?

Please let me know if you have questions or if something is unclear.
Thank you!

Hello Narisha,

thank you for your post.

You could try the following formula: Join$(Distinct(<Your_Field>))

Best regards,

Patrick Preuschoff
Technical Support
combit GmbH