Ranking in Script

[Anonymous]

Hi,

I need help with this Rank situation (Aggr with Dimensions) and it must be made on Script (Not in set analysis).

Situation:

Platform	Site	Value
Mobile	EN	100
Mobile	IL	300
Mobile	DE	150
PC	EN	200
PC	IL	400
PC	DE	600
Crypto	EN	400
Crypto	IL	300
Crypto	DE	100

Wanted Result:

Platform	Site	Value	Rank
Mobile	EN	100	3
Mobile	IL	300	1
Mobile	DE	150	2
PC	EN	200	3
PC	IL	400	2
PC	DE	600	1
Crypto	EN	400	1
Crypto	IL	300	2
Crypto	DE	100	3

[Anonymous]

Geat Thanks!!!

[padales1]

Hi Sunny,

Could you please explain how adding 1 and 2 make this work? what is this identifier?

[fabdulazeez]

I think the autonumber  returns a unique integer value for each distinct evaluated value for entire script execution.So for the second and third time,it can encounter a similar value as the previous one. To make it different  counter instances we can add something(here 1 and 2 ) to make it distinct