Create a dimension to concat the values of another dimension

Looker Q&A Looker
1

Hello,

Is there a way I can create a custom dimension to concat the values of another dimension?

For example

User ID

Order created at

Fruits

All Fruits

54

Jun 15

Apples

Apples, Pears, Oranges
54Jun 16Pears

Apples, Pears, Oranges
54Jun 17Oranges

Apples, Pears, Oranges

“All Fruits” is the concat of all values in “Fruit” dimension.