8 Replies Latest reply: Apr 21, 2017 5:16 AM by Vineeth Pujari RSS

    Rank Function

    Manoj Kulkarni

      Hi Friends,

       

      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 ?

       

       

      1Queried
      2Reviewed
      3Closed
      4Resolved
      5Completed
      6Queried
      7Reviewed
      8Closed
      9Resolved
      10Completed
      11Closed
      12Resolved
      13Closed
      14Queried
      15Reviewed
      16

      Queried

      Expected Out put : Resolved & Reviewed appear 3 times, but it has to be sorted on basis of alphabets.

      Queried4
      Resolved3
      Reviewed3