Numeration in a chart

[Anonymous]

Hello,

I want to numerate values in a chart as the example I atatched. There is some formula that I could use?

Thank you,

Sara

[sunny_talwar · Accepted solution]

Try Rank() function:

Rank(Expression)

[perumal_41]

Hi Sara,

numerate which based on want to calculate i.e highest values based on or sort order based

[ThornOfCrowns]

How are you getting the numeration for the value 'r' in Field A? It's neither value of expression or sort of Field B.

[Anonymous]

It works in  the pivot table sorting by the expression rank,

Thank you