Ranking vendors

[ValeriaBonini]

Hi, I have a formula like this:

=rank(total(PRICE))

How can I show the rank based on the total? My output should be like this:

VENDOR PRICE RANK

AAA 45 2/4

BBB 34 3-4/4

CCC 67 1/4

DDD 34 3-4/4

I think that should be something like:

=rank(total(PRICE))&'/'& RowNo() but it doesn't work...

[Aditya_Chitale]

try :

rank(total(PRICE)) & '/' & count(total any_dimension)

Regards,

Aditya

[hic]

Is PRICE a field or a measure? If it is a field, you may need to change the expression to

Rank( total Avg(PRICE) ) & '/' & Count(total VENDOR)

Note that Rank() takes an aggregation as first parameter. Note also that there is no function 'total'.