This content has been marked as final. Show 8 replies
I need to display top 3 text with there number of occurrences along with sorted by alphabets. Below is the input table with serial no & text description. In the expected result Resolved & Reviewed appear 3 times,so it has to be sorted on alphabets to meet the requirement.
what would be the Rank() function or any other way to achieve ?
Expected Out put : Resolved & Reviewed appear 3 times, but it has to be sorted on basis of alphabets.