But there is one person who is additional and i don’t want to see him in this report. I could use Assignee pages, select all, and deselect this person, although it’s not the best solution.
Is there a way to make a group of all assignee without this person? I tried to make a Calculated Member in Assignee group, but it works as a sum of all member without this one, not like a group of people that i need.
Yes, you may create a group of all assignees except one particular or several users. In Assignee dimension define a new calculated member which aggregates all users except listed user or users:
Aggregate(
Except(
--set of all assignees
[Assignee].[User].Members,
--list of user names which should be excluded
{ [Assignee].[Admin Shakespeare] }
)
)
In the same way, can we include only particular users.
I have a list of users, instead of exclude the users by using except I want to include few users to the report and that need to be displayed under All Assignee list in the report.