3 Replies Latest reply: Oct 4, 2016 4:48 AM by Sushil Kumar RSS

    Ranking values by Fields

    Deepak Sharma
      CountrySalesSales RankQtyQty RankNetNet Rank
      India100120210001
      Sri Lanka200210130003
      Nepal300340450005
      US400430320002
      UK500510140004

       

      I have arround 50 countries in data sets, based on Sales , Qty and Net value I have to rank them.

       

      Can some one help me out how to achive this. Also I wand to display in straight table/Pivot table.

       

      Many Thanks in advance.