Problem with aggr()

[#1]

Hi to everyone,

I've a problem I can't solve. This is my table:

Field_1	Field_2
A	X
A	-
A	X
A	-
B	-
B	X
B	-
B	-
B	Y

this is what I need to obtain:

Field_1	Field_2
A	X
B	X, Y

Using the Aggr() function:

Aggr(Field_2,Field_1)

I'm only able to obtain this:

Field_1	Field_2
A	X
B	-

How can I extract also the 'Y'?

Thanks a lot!

[sunny_talwar · Accepted solution]

Try this

Concat(DISTINCT Field_2, ', ')

[#3]

The complete syntax was:

Aggr(Concat(DISTINCT Field_2, ','), Field_1)

[#4]

Great thanks!

[sunny_talwar]

Were you using this as a dimension?