report problem

[johnny.g]

hi all,,,need a little help from u ppl.
i am creating reports using bi of vs along with cubes. here is the example of my report..

country qty rate rate qty
a 15 200 2
b 10 400 3
c 20 300 1

i am able to achieve the first three columns....the problem is the third column.. what i need is ,here the rate qty shows the ranking based on the qty....eg for qty 20 rate is 1,,for qty 15 rate is 2 and for qty 10 rate is 3......how can i achieve this...
any help on this will be grateful..
pls reply asap.
thnks in adv

[johnny.g]

HI all,, can anyone shed some lights on this problem...
thnks.

[dnanetwork]

i think you can user row_number and sort the qty rate
it will generate a column for you which is required..

search for Row_Number..you'll get the idea..!

[johnny.g]

i think you can user row_number and sort the qty rate
it will generate a column for you which is required..

search for Row_Number..you'll get the idea..!

hii,,thnks for ur reply..do u have any kind of code sample for the same..i am creating the reports using olap cubes..

[dnanetwork]

http://msdn.microsoft.com/en-us/library/ms186734.aspx

http://www.databasejournal.com/features/mssql/article.php/3572301/RowNumber-function-in-SQL-Server-2005.htm

http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/server.101/b10759/functions122.htm

hope this helps!