From what I understand, appsheet doesn’t let you sort columns in a chart by group aggregate. I know there’s a workaround where you can create virtual columns to “hardcode” the order of columns, but I want to dynamically order them by a Sum.
I’m trying to create a sales leaderboard where a chart or table can be sorted from highest seller to lowest. Instead of the Salesperson columns being ordered alphabetically, could I somehow index the sum of sales by salesperson and append a 1,2,3 etc on it? See below for a very simplified example: