Sorting histogram workaround

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:

2X_b_bb2a4b7e7d18b9a131ebfd78e6f49a649c84fb63.png

1 1 867
  • UX
1 REPLY 1
Top Labels in this Space