Show Single Rank Value

[#1]

How can I display individual ranks of items?

An simple example, I have this table:

Name          Sales

Bob               100

Mary              300

Ted                 50

Using Rank in a chart is simple enough.  But how do I list a single rank for a person in a text object.   So I want to display:

Bob  2

Since Bob is second in the ranking.

(this must be very easy, I hope??)

Thank you!

[rustyfishbones]

Hi you can create a Text Box and type the following Expression

when you slect Bob the text box will show 2

If you add this

you will get what you need

[Clever_Anjos · Accepted solution]

='Bob : ' & only({<Name={"Bob"}>}aggr(rank(Sales),Name))

[#4]

Perfect, thank you very much!