Sorting Filter

[anitamarie2020]

Hi all, 

I'm using the sort filter to select the largest 10 balances and smallest 10 balances to the top of the listing. However I still want the remaining information to be underneath. Is there anyway I can do to this

Thanks,

Anita 

[mot]

Hi @anitamarie2020,

After you sort, you can use sample to get the first 10 rows as a new table, the last 10 rows as a new table, and then use sample to skip the first 20 rows to get the rest of the rows. Lastly, you can use union to bring the whole data back together. I hope this helps. Best.  

[anitamarie2020]

Thanks MOT - At what stage should I add the new sort tool to skip the first 10 rows for example?

[mot · Accepted solution]

Hi @anitamarie2020,

Here is a sample workflow:

Workflow attached. I hope this helps. Best!

[anitamarie2020 · Accepted solution]

Thank you so much @mot 

That solved my issue - thanks again 🙂 

I won't tell you how long I spent trying to figure that out myself!!