Here’s how sorting works on Numbers, Apple’s spreadsheet program:
Notice that, where the Category values are equal, the Amount values remain sorted in descending order.
In table view we can easily sort by tapping on the header at the top (if the headers are displayed). However, when we tap on another header, AppSheet seems to forget what it has just done and sorts the table as though a sort had not preceded it.
If it’s not too difficult (or too expensive in terms of computing power), I think it would be great if AppSheet’s table sort could remember preceding sorts in the manner I’ve described here.