6 Replies Latest reply: Sep 2, 2017 4:20 AM by Rohit Kumar RSS

    Rank by Particular Dimension value

    Rohit Kumar

      Hi Techies,

       

      I am facing a problem where I need to populate the rank by each Material so I can find the difference between top MAP to previous position MAP i.e  (101,4099,200 )  and (101,4090,100,) w.r.t to each and every Material, the data I have :

       

      Test:

      load

      *

      Inline

      [

      Material ,WERKS,MAP

      101,4069,10,

      101,4066,20

      101,4090,100,

      101,4099,200,

      102,4069,30,

      102,4066,50,

      102,4090,100,

      ];


      expected output:


      Material ,WERKS,MAP,Rank

      101,4069,10,1

      101,4066,20,2

      101,4090,100,3

      101,4099,200,4

      102,4069,30,1

      102,4066,50,2

      102,4090,100,3

       

      Please take this on priority basis

       

      Best,

      Rohit