Write a set analysis based on the connected property of a selected dimension

[cengizeralp]

Hi guys,

I have a "Personal identity" dimension. If I choose one from this list, I want to show all people in the same department with this person in a table.
Please tell me how I can write this with a set analysis.

thx in advance

Cengiz

[cengizeralp]

I have found a solution finally.

I wrote the below set analysis at one column (calculates the number of people has the same cost center) : 

Count ({<[Pers_id]=, [Cost_center]={$(=Only({<[Pers_id]={$(=GetFieldSelections([Pers_id]))} >} [Cost_center]))} >} [Name])

And at the next columns: [Name], [Surname], etc (that fields offers the all personal data one by one)

thanks to everyone interested.

Cengiz

[sunny_talwar · Accepted solution]

Can you try this

Count({<[Pers_id], [Cost_center] = p([Cost_center])>} [Name])

[cengizeralp]

You are awesome Sunny,

thx a lot,

Cengiz

[sunny_talwar]

No problem, glad I was able to help make the expression little easier to read.