hey maybe i didn't quite understood your problem
those your dimension in the same table
in that case why do you need set analysis ,when the user select a title
the function avg(Score) will return the avg of all scores of names with the selected title
if you want the avg of all names scores you can go with avg(aggr(avg(Score),Name))
hope it helps you
Thank you for your reply. I think i could not express myself clearly.
Indeed what i want to do is , when user selects a name (lets say the name is Liron and his title is manager)
I want to calculate the avarage score of all the other names that belongs to the manager title.
avg(score) returns only the avarage score of Liron over other dimentions.
I couldnt figure out what avg(aggr(avg(Score),Name)) does, but it also do the calculation only over Liron.