Action : Select in field on the five last values sorted

[fredericvillemi]

Hello,

I would like to have a button that select the first or last 3 values sorted in a specific order.

For example, I have a field "Level" which contains values like

'AB'

'CDE'

'FG'

'H'

'IJKL'

And I would like to have an action which automatically select the first 3 sorted in ascending order. (but as they may change, I can't put the names or a part of the name)

Is there a way ? with Concat or Aggr maybe ?

Thanks

[tresesco · Accepted solution]

May be like attached sample

Search String:  ='('&Concat(DISTINCT {<Dim={"=Rank(Dim)>$(=Count(Distinct Dim)-3)"}>} Dim, '|')&')'

[fredericvillemi]

Absolutely excellent

And if I want to have the last 3 ?

Thanks

[tresesco]

little simpler: ='('&Concat(DISTINCT {<Dim={"=Rank(Dim)<4"}>} Dim, '|')&')'

[fredericvillemi]

Brilliant !

Thanks !