How to find Sales by rank

[#1]

Hi

I have a Deliver table is there ..

a     b     c     d     Sales

1     x     y     z     100

2     m     n     o     200

3     c     d     e     300

4     i     j     k     500

for this above data,i want to find the rank based on dimension .my data will show like this

I have a Deliver table is there ..

a     b     c     d     Sales  Rank

1     x     y     z     100     1

2     m     n     o    200     2

3     c     d     e     300     3

4     i      j     k      500     4

Can any one please write expression fro this one...

Thans

[hic]

Rank(Sum(Sales))

HIC

[amit_saini]

Hi Roshan,

Please see the attachment.

Thanks,

AS

[#4]

Thanks for giving quick reply..

I applied ..but i am getting only '1' for all the sales

[hic]

You need to post an app if we are to see what has gone wrong. But..

- You need to use it as expression in a chart that has a dimension, e.g. Customer

- You need need to make sure that the argument is numeric, e.g. Sum( Sales )

HIC

[senpradip007]

PFA.

Note: Dont go with the application name.

[senpradip007]

Hi

Use this

Rank( TOTAL 1/  Sum(Sales))

[sunilkumarqv]

use these  into you expression

=Aggr(rank(sum(Sales)),Sales)

[sunilkumarqv]

like these

[sunilkumarqv]

Previous post what i mentioned according to sum(sales) if you want output like yours

try these

=Aggr(rank(-sum(Sales)),Sales)

O/P:

a     b     c     d     Sales  Rank

1     x     y     z     100     1

2     m     n     o    200     2

3     c     d     e     300     3

4     i      j     k      500     4