set analysis

[Anonymous]

hello

I have a excel file like bellow:

name  telephone

aaa      2222222

bbb      8888888

bbb      9999999

aaa      2222222

i want to show the names with 2 different phone number like "bbb"

i would appreciate if anyone can help me in writing set analysis.

[Kushal_Chawda]

try this

If(aggr(Count(Distinct telephone),Name&Month) > 1, Concat(telephone, ',', 0)

[jagan]

Hi,

Adding Month dimension will solve this issue, did you tried it.

If you do not want to add then try below expression.

Chart: STraight Table

Dimension: Name

Expression: Concat(Aggr(If(Count(Distinct telephone) > 1, telephone), Name, Month), ',', 0)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

it didn't work too, i add dimension thank you

[Anonymous]

The expression didn't work but i add dimension and it worked thank you so much