Sum a group

[#1]

Hello

I thought this is doable with set analysis but I cannot seem to find a way.

I need Sum(Score) for Study ID when a user has selected one of the User ID.  

User ID	First Name	Last Name	Study ID	Score
1	a	b	1	4
2	c	d	1	2
3	e	f	1	1
4	aa	bb	2	2
5	c	d	2	4
6	ee	ff	2	2

In this data, a user may select Last Name = b. The last name b has study ID =1 so in that case I need the sum of score to be 7.

If a user selects Last Name = d; that has study ID 1 and 2. So the Sum needs to be 15.

How to do that?

Thanks

[sunny_talwar · Accepted solution]

May be this:

Sum({<[Last Name], [Study ID] = P([Study ID])>}Score)

[#3]

Worked like a charm. I included the other columns and it works perfectly.

Sum({<[User ID], [First Name], [Last Name], [Study ID] = P([Study ID])>}Score)