Sorting in a list

Hello, Guru of Adalo!
Help me solve what I think is a simple problem.
There is a team of sales people selling different products. Each transaction has a final transaction amount.
I’m creating a list of sellers with total monthly sales and I want to sort this list from maximum to minimum.
I use the ‘Sum’ function in the list. However, I can’t sort by it.
Help me please!

Hello @olegshevchenko4914

You would have to store the sum of each sellers orders in the "sellers’ table.
So each time an order is made, update the seller total value.

A bit clunky and open to errors, but that’s the way it is. A batch update process would be a good idea to rule out errors creeping into the total sum over time.

I would use Xano for these collections, there you could get quite precise with your sorting and building these reports.

1 Like

Thank you very much! As a matter of fact my platform is much more complicated. I just asked to get confirmation that I understand right the weakness of Adalo in such a mechanics. One more time - thank you.

1 Like

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