sort by date and quantity

[bestgroup]

I created input forms in which each user enters their name and a quantity, every day. In edit view I can sort the view by date. Within the date I can see all the users to whom I have associated (through group aggregate) the sum of the quantities for each single day. I would like this view, within each date, to be sorted from largest to smallest quantity. The sorting should be: by date of the day, then by username from the one who produced the most to the one who produced the least. It's possible? Thank you

[Suvrutt_Gurjar]

Please go through the help article below:

Control row sort order - AppSheet Help

Control grouping - AppSheet Help

[bestgroup]

I read the help article but I couldn't find the solution. I put in "group aggregate" SUM: quantity (the number each user input in the forms). But I'm not able to find the correct combination between "sort by" and "group by" in the edit view to obtain what I need. I would like the obtain an instant view by date (and this is simple). Then, clicking on each date, the view should display the name of users in descending view by sum quantity. Instead I always get a view sorted alphabetically by username.

[Suvrutt_Gurjar]

Assuming you have a summary view such as table, please try group by "date" (Ascending or descending as you want), followed by group by "Quantity" (descending).

[bestgroup]

thanks anyway but it doesnt's work as I'd like.