7 Replies Latest reply on Apr 12, 2018 2:46 PM by Varun Amin

    Sorting and Ranking Top N values using Rank function.

    Varun Amin

      Hi,

       

      I want to create a worksheet where I can select a particular field from drop down and the list changes accordingly and also can select the top categories. But when I filter top 15 records, it randomly selects the first 15 and not according to rank.

      Have created the Rank using rank function and have sorted it in descending.

       

      Please suggest any changes that need to be made. Thanks!