HOW TO: Find the Three Largest Values in a Column

HOW TO: Find the Three Largest Values in a Column

Calculate Third Largest Value

Step 1 to identifying the three largest values in a column is to calculate the third largest value. To do this, you will need to Derive a new column and use the KTHLARGEST() FunctionThis will create a column containing the third largest value of the column you are evaluating.

Create Binary Indicator Column that Identifies Three Largest Values

Once you have Derived the third largest value, you will use this to identify whether or not a value in the column you are evaluating is greater than or equal to the third largest value. This step involves creating a binary indicator column, again using the derive transform. The result will specify true for values greater than or equal to the third largest value, and false otherwise. We can filter down on the true values to check that this is the case.