New column with ranking

[ValeriaBonini]

Hi, i have a table that looks like this:

VENDOR       PRICE

aaa                50

ggg                 76

eee                22

and i would like to have a new column with a rank based on the price for the vendor: (made with set analisys not in the script)

VENDOR      PRICE      RANK

aaa                50             2

ggg                 76             1

eee                22              3

how can i do this?

[Aurelien_Martinez]

Hi,

You can try : Rank(TOTAL PRICE)

[vinieme12]

As below

Rank(Sum(Price),4,2)

[ValeriaBonini]

If i use this, if i clik on another column it will change my ranking, i want it to be all the same based on total price and not other fields

[ValeriaBonini]

If i use this, if i clik on another column it will change my ranking, i want it to be all the same based on total price and not other fields

[vinieme12]

As below

Aggr({<Vendor=>} Rank(Sum({<Vendor=>}Price),4,2), Vendor)

[Aurelien_Martinez]

Rank(Total Sum({<VENDOR=>} PRICE))

[ValeriaBonini]

My formula is like this:

=rank(total([PRICE]))

How can i make it static? i want it to ignore all selections made by the user