Share
Report
1,937Hi,
Trying to apply sort function to sort/filter gallery where only showing first 10 rows.
Column1 and Column2 have numbers and all i want to display is first 10 lines where numbers in total (column1+column2) or column1, column2 is going from biggest to smallest..
FirstN(Source,10)All it does is shows me the first 10 lines and that's it.
Tried many different methods.
Latest how far I've got:
FirstN(Sort(Source, Or(And(Column1,Column2),Column1,Column2), Ascending),10)
I would probably need to collect a new collection where data is filtered to get first 10 rows of biggest numbers from both columns.
Just don't know how to do this..
If somebody can give me an option then thanks.
Categories:
I have the same question (0)
All responses (
Answers (
