5 Replies Latest reply: Apr 18, 2017 10:41 PM by alvinford ford RSS

    Rank Function Help

    alvinford ford

      Hi All ,

       

      I have the below table , the requirement is to rank the UserName based on the sales value and display the first three UserNames as in the output shown below. Please help to get this requirement.

         

      UserNameShopNameSalesValue
      XABC100
      YABC90
      XABCD100
      YABCD90
      XABCE90
      YABCF100
      ZABC80
      ZABCG90
      VAAA80
      ZABCF100
      VABC80
      UABB70
      VABCD80
      UABD80
      VABCF20

       

       

      Output

         

      RankUserNameShopNameSalesValue
      1XABC100
      ABCD100
      ABCE90
      2YABC90
      ABCD90
      ABCF100
      3ZABC80
      ABCG90
      ABCF100

       

      Thanks & Regards,

      Alvin