Numbering the top 10

[Former Member]

Hello BW Experts,

We need to give the first column in the top 10 customers report as the serial number from (1...10).

sol1) storing the serial numbers statically in the cube is not possible because, the time period selection in the query is dynamic, the user can select the top 10 customers in any period like month, day, week, year.

Sol2) One probably way of achieving this is using virtual chars.

sol3) ???

Q1) Please suggest any alternate way of getting the serial numbers for the cust top 10. ?

Q2) Is there any standard functionality to achive this?

Any suggestions highly appreciated.

Thanks,

BWer

[Former Member · Accepted solution]

U can achieve this in BEx.