Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Sum({<[Last Name], [Study ID] = P([Study ID])>}Score)
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)