return first, second and third rows of a table

[samuel_brierley]

hi all,

ive created a resident table that groups values and sorts them top to bottom and i want to be able to use a first that will return the first, second and third area

Area

Area	Value
a	4
b	3
c	2
d	1

[Chanty4u]

sort tab  sort by ascending by value.

or

in dimension limit   give 5

[samuel_brierley]

no i would like to use the return the value in a text box

[sunny_talwar · Accepted solution]

May be this:

In a chart

Only({<Value = {"$(='<=' & Max(Value) - 2 & '>=' & Max(Value))"}>} Value)

In a text box

Concat({<Value = {"$(='<=' & Max(Value) - 2 & '>=' & Max(Value))"}>} Value, ', ')

[samuel_brierley]

Cheers sunny