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