RG: List sorting - Help needed


I’m trying to make a sales leaderboard.
I made a Sales datatype for the individual sales transactions, which is connected to a list field in the User datatype.

In the repeated group I’m searching for “Users”, and I’m using :count to count the amount of sales in the User’s list of sales. It all works, I just can’t figure out how to sort the list by the highest sales :count as bubble doesn’t allow me to sort with a list field. How can I solve this?

Thank you

Just tried this, doesn’t work too…

My first thought is to check out if it is possible using the ‘change which field…’ operator

Tried this, it breaks the repeating group…