Present only the max value

[gal_polak]

Hi all, 

I have a table that present for each question the user answer and the number of attempt he made for this question, see example table:

Quiz Attempt Number	Quiz Question	Answer	User Code
1	- Did the Seller acknowledge how they feel about the change?	true	DE1561
2	- Did the Seller acknowledge how they feel about the change?	true	DE1561
1	- Did the Seller acknowledge how they feel about the change?	false	DE1654
2	- Did the Seller acknowledge how they feel about the change?	true	DE1654
1	- Did the Seller acknowledge how they feel about the change?	true	DE1679
2	- Did the Seller acknowledge how they feel about the change?	true	DE1679
1	- Did the Seller acknowledge how they feel about the change?	true	DE1781
2	- Did the Seller acknowledge how they feel about the change?	false	DE1781
1	- Did the Seller acknowledge how they feel about the change?	true	DE1833
2	- Did the Seller acknowledge how they feel about the change?	true	DE1833
1	- Did the Seller acknowledge how they feel about the change?	true	DE2013
2	- Did the Seller acknowledge how they feel about the change?	true	DE2013
1	- Did the Seller acknowledge how they feel about the change?	true	DE2734
2	- Did the Seller acknowledge how they feel about the change?	true	DE2734

I would like to present for each user and question only his last attempt, 

i know i need to use aggr and max functions so how, but i wasn't able to find the solution, can someone help? 

[Thiago_Justen_]

FirstSortedValue([User Code],-Aggr([Quiz Attempt Number],[Quiz Question],User Code)) >>>>> results in User Code

Edited - there was two commas after Quiz Question:

FirstSortedValue([Quiz Question],-Aggr([Quiz Attempt Number],[Quiz Question],User Code))>>>>> results in Quiz Question

[gal_polak]

I tried implementing the code you wrote in the two columns,
but i get "Invalid dimension" 😞