Repeating rownumbers for duplicate rows?

[naveen10046]

Hi Guys,

I have a requirement to display rownumber in the below format :

Number   Name
1    Alexandra Trower
1    Alexandra Trower
1    Alfonso Emanuele
1    Alfonso Emanuele 
2    Ampornpim Vajrabhaya
2    Ampornpim Vajrabhaya
3    Amy DiGeso
3    Amy DiGeso
3    Amy DiGeso
4    Andreas Serpanos
4    Andreas Serpanos

Thanks in advance
Naveen

[naveen10046]

Hey Guys,

I got the solution, here it is:

Need to create a dataitem with the expression :

running-count(distinct[NAME])

Regards,
Naveen