Fisrt 5 Rows of table

i have table and i want to get first five rows, what should i do?

Dear @amin_jebeli ,

Please check out this post where the logic is explained.

In case you have more questions, feel free to address them back.


thank you @Jean_Pierre_Traets
i use this formula:

thisRow.In(thisTable.Sort(false, thisTable.value).Slice(1, 5))

if i want to add descending sort to this formula, what should i do???

Dear @amin_jebeli,

I didn’t test it, but:

Change false to true, should do the trick :dart:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.