topic Re: Rank by Particular Dimension value in Management & Governance

Rank by Particular Dimension value

rohitk1609 — Fri, 01 Sep 2017 09:59:43 GMT

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

Re: Rank by Particular Dimension value

kenphamvn — Fri, 01 Sep 2017 10:20:06 GMT

Try

load *, AutoNumber(Material&WERKS,Material) as Rank

Resident Test;

Re: Rank by Particular Dimension value

kaushiknsolanki — Fri, 01 Sep 2017 10:24:39 GMT

Hi,

Try this.

load

*,AutoNumber(WERKS,Material) as Rank

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,

];

Regards,

Kaushik Solanki

Re: Rank by Particular Dimension value

antoniotiman — Fri, 01 Sep 2017 10:30:42 GMT

AutoNumber(WERKS) as Rank

Re: Rank by Particular Dimension value

kusumanchir — Fri, 01 Sep 2017 11:19:48 GMT

Hi Rohit,

Please try this as your expression,

aggr(rank(-MAP),Material,WERKS)

Regards,

Rasly.K

Re: Rank by Particular Dimension value

sunny_talwar — Fri, 01 Sep 2017 11:20:53 GMT

Looking to do this in script or front end of the application?

Re: Rank by Particular Dimension value

rohitk1609 — Sat, 02 Sep 2017 08:20:28 GMT

I was trying to do it on back end and AutoNumber(Material&WERKS,Material) works fine.