Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cengizeralp
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
sunny_talwar

Can you try this

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

View solution in original post

4 Replies
cengizeralp
Contributor III
Contributor III
Author

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

Can you try this

Count({<[Pers_id], [Cost_center] = p([Cost_center])>} [Name])
cengizeralp
Contributor III
Contributor III
Author

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.