3 Replies Latest reply: Nov 8, 2011 5:41 AM by Michael Street RSS

    How to select all from a field, excluding selected?

      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.