Show all names around current selection

[pauldamen]

All,

I have a sheet where information provided is per employee. The employee is selected in a listbox.

On the tab I also have a table where I want to show a benchmark of all team members of the team where the selected employee is in, with some figures.

How do I show the numbers for all the teammembers belonging to the team the selected teammember is in even though 1 employee is selected?

Regards, Paul

[sunny_talwar]

May be this in the set analysis:

{<Employee, Team = p(Team)>}

[lironbaram · Accepted solution]

your expression should look like this

sum({<employee=,Team=p(Team)>}X)

this way in the expression you disregard the selection in the employee field

but you select to display only teams that are in the current selection set of data

[pauldamen]

Thanks for the quick explanation, works like a charm