Totally Lost - Is there any way to rename sums to a ranking? As in highest sum says 1 instead of sum

[Anonymous]

I have a table with sums and I am wanting the highest sum for the question in the column to say 1, second highest to say 2, 3rd highest to say 3...etc. 

[Oleg_Troyansky · Accepted solution]

Hi there!

The function name is Rank(), and it does exactly what you need:

Rank(Sum(Sales)) will return numbers 1, 2, 3 etc. Find it in the Help section for more details about an optional second parameter.

Cheers!

[Anonymous]

Ah...very neat. Thanks Oleg!

Are you only to rank down a column or can you pull this off doing it across a row in a pivot table as well? 

I am reading about something called HRank, but I am not sure if I fully grasp how to use that. 

[Oleg_Troyansky]

I never had a chance to use HRank, but it sounds like it would do the job in the Pivot table.