Error in calculated dimension

[pgalvezt]

Hi, I'm Traying to use the function Distinct for eliminate duplicate text.

like:

P

P

A

M

M

S

I need

P

A

M

S

I have =Concat(Distinct(Field))

But appear an error.

Thanks

[jonathandienst]

Hi

Normally, the rows with the same value get aggregated in the chart anyway. There is no need for a calculated dimension for this purpose. Just use the field as a dimension.

Regards

Jonathan

[Clever_Anjos]

You don´t need this, if you use a field as dimention, QV will use only distinct values.

[pgalvezt]

I tried:

=Concat(Distinct Field)

Nothing Happened.

[pgalvezt]

I put my field as a dimension this is my result for 1 account:

Sells

Sells

Sells

Sells

Sells

So on

[pgalvezt]

I think with concat and distinct functions should be working.I think something missing

[Clever_Anjos]

Could you post a sample of your app?

[pgalvezt]

Thank you for your replys guys. I can't send you a sample because my model is too heavy 300MB. But I Attached a file picture That I have.

Thank you!

[Clever_Anjos]

Please send a pic of your Dim and Expressions tabs