0

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

2
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by dnanetwork
0

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

0

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..!

0

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..

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.