Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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 | 
 
					
				
		
 swuehl
		
			swuehl
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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 | 
 
					
				
		
Thanks Stefan
