Ranking of entities results

[Shalom1]

Hello,

I'm trying to check which in order Haulier Group is.

In the table I use RANK function to do that but I want to receive a simple informaition, e.g.:

you are 9 of 20.

For now I have this:

Rank([Haulier_Ranking])

Please, help 🙂

[Shalom1]

What do you mean by 'Target_Group'?

I have a list of 100 groups of hauliers (my Dimension). Haulier_Ranking is my measure

I'd like to have a possibility to choose the Haulier_Group in my filter and see the ranking for him in my KPI window