Restricting values in a table to the top X

[orangebloss]

Name	Max(Pax)	Rank(max(Pax))
John	20	1
Mark	19	2
Mabel	18	3
Sarah	15	4

I've created a table as above but what I want to show is only the top 3 - I've tried various different ways but haven't quite worked it out?

Any help appreciated!

[Padma123]

Max({<Name={"=rank(max(Pax))<=3"}>}Pax)

[MatheusC]

@orangebloss 

Restricting values the top X by its dimension,

=aggr(only({<Name = {"=Rank(max(Pax), 4)<=3"} >}Name), Name)

In the dimension, uncheck include null values ​​/ Show others

- Matheus