How to select all from a field, excluding selected?

[#1]

Hi all.

I have a dashboard that shows activity for team members.

A person can belong to more than one team.

Activity is displayed for one team only (the team list box has Always One Selected Value checked).

I need to list the other teams that a user belongs to in a text box, excluding the currently selected team.

Example:

Bob has activity for TeamA and TeamB.

User selects Bob and TeamA.

Bob’s TeamA activity is displayed.

I now need to alert the User to the fact that Bob also has activity for TeamB.

The following lists all teams that Bob belongs to (including TeamA):

Dimension: Team

Expression: =count({<Team=>}Activity)

How can I exclude the current Team selection (TeamA) from the above expression?

Thanks in advance, Michael.

[Anonymous]

If it is only possible to select only 1 team value at the time you could use GetFieldSelections ...

And when using in a set analysis:

Team -= {$(variable)}

[swuehl · Accepted solution]

try

count( {<Team= e(Team) >} Activity)

Hope this helps,

Stefan

[#4]

Perfect – thanks for your help!