Hello, I want to display the largest two values for each ID. My dataset is as follows: ID Value A 3 A 4 A 5 B 10 B 3 B 7 C 10 The result should look like: ID Largest two values A 4 A 5 B 10 B 7 C 10
... View more
Hi all, I need some help to obtain the max value and previous max value for each unique ID. Below is my dataset. I used the calculated values and Rank but it does not seem to work by grouping by ID. ID Value A 3 A 4 A 5 B 10 B 3 C 10
... View more