Dynamically exclude values in set analysis

[#1]

Hi, I have a line chart that I want to show the 3 lines:

1. a team total

2. figure of one person

3. combined figure of all other people in the same team except the selected person

I managed to do the first 2, but couldn't figure out how to do #3 as the selection will change so I cannot hard code the values in the set analysis expression.

qvw is attached. Thanks!

[Gysbert_Wassenaar · Accepted solution]

Try Sum({$<Year=, Person=E(Person)>} Hours) / Count(DISTINCT {$<Year=, Person=E(Person)>} Project)

[#3]

Thanks so much! Exactly what I was hoping to do!