Creating a list in a table

[firmographs]

We have data loaded like this, in 2 columns:

A   1

A   2

A   3

B   1

B   2

The output we want is this, with the values comma-separated, again in a 2-column table:

A  1,2,3

B  1,2

Ideally, we would achieve this, if possible, while we are creating the table rather than in the load script.  This way the list in our table cell would be generated dynamically based on filtering, etc.  

How would we approach this?

[rwunderlich · Accepted solution]

Dimension: Col1

Measure: Concat(Col2, ',')

-Rob

[firmographs]

Thanks!