3 Replies Latest reply on Aug 12, 2016 7:25 AM by Phillip Overpeck

    Top 3 sales using only TY sales and Remaining country should be "Other"

    Arasu

      I am using country wise sales TY and Sales LY, here i need top 5 country based on only TY sales. i used Rank function but it is considering based on LY Sales also,

       

      Ex.

      country     TY        LY   

      USA         $50       $10

      UAE         $40       $30

      IND          $30       $25

      UK           $23       $15

      Japan      $18       $28

       

      I need output like below

      country     TY        LY   

      USA         $50       $10

      UAE         $40       $30

      IND          $30       $25

      Other       $41       $43

      UK           $23       $15

      Japan      $18       $28

       

      i used Set and Rank calculation but it is showing based on LY value also which i dont want.  can anyone please help me on this ?