Rank within Group

[#1]

Hello

I am trying use Rank to get the rank for the User.

In the following data, if a user selected UserID = 2 then ranking based on Score;

I need to show 2 rows

- first for Study ID 1 with rank 2

- and second for Study ID 2 with rank 1.

How do I accomplish that?

User ID	First Name	Last Name	Study ID	Score
1	a	b	1	4
2	c	d	1	2
3	e	f	1	1
1	a	b	2	2
2	c	d	2	4
3	e	f	2	2

Thanks

[swuehl · Accepted solution]

Maybe create a straight table chart with 1 dimension and 1 expression

Study ID	=Only(Aggr(Rank(Only({1}Score)), [Study ID], [User ID]))
1	2
2	1

[#3]

Thanks Stefan