average by subfield excluding selection

[#1]

Group	Team	Person	Value
A	T	Anne	2
A	T	Ben	2
A	T	Claire	4
A	U	Dave	6
A	U	Ed	2
A	U	Frank	4
B	V	George	6
B	V	Harry	8

Hi Guys,

Could someone help me with a chart expression? The user has a list box for Person so they can select an individual.

When the user selects a person, i need an expression which averages the total of the whole of their team, excluding that selected person.

Essentialy this chart shows the Average for that indivial (expression 1) and wants to compare them against the average for the rest of their Team (expression 2).

In the example above, if a user selected Anne, expression 1 would show "2", expression 2 would show "3" (Ben's "2" + Claire's "4" / by the both of them.

Hopefully his makes sense, please let me know if you need more information.

Thanks,

[Gysbert_Wassenaar]

See attached qvw

[#3]

Hi,

To get your requirement use Set analysis function E()

Use Expression like

Expression1 = Avg(Value)

Expression2 = Aggr(Avg({1}Value),Team)

Regards,

Vivek