How can i sort large to small qty.
AppSheet does not support Sorting on the Aggregated Value shown in your Grouped Table View. Nor does AppSheet allow sorting of the Groups by some other column. If you must sort by that Count at the grouping level, then you would need to add the Count into the Group Header. It would require:
- Defining your own Count column
- Appending the Count to the FRONT of your Group Header column or add a new column that Concatenates the Count and the Group Header in that order.
- Use the combined Count + Group Header as the grouping column set to Descending.
1 Like
@WillowMobileSys @Please share The Expression. Better help.
1 Like
I wish they can help us with sample
1 Like
I hope this message finds you well. I am writing to express my concern regarding a query I posted in the AppSheet Community. Despite patiently waiting for a response, I have not received any reply or assistance thus far. As the matter is urgent and time-sensitive, I am reaching out to you directly in the hope of obtaining the assistance I require.
I understand that the AppSheet Community is a busy platform with many users seeking support, but I kindly request your attention to my inquiry.
Expression for what? If you mean to simulate the Group Header count in the “Count Column” then it would be something like the below. This is of course assuming that the value you are showing is SUM.
“Count Column” Expression
SUM(Your Table[Value to be summed], [Group Column] = [_THISROW].[Group Column])
NOTE: you need to replace the table and columns with those in your app.
I would add this column as a Virtual column so that if ANY of the rows are changed, all of them get updated with the correct summed amount.
There are no samples for this. I personally would not use the Grouped Table view for this. But that is what the post is asking for.
So…to round out the additional details I previously mentioned
Appending count to FRONT of Group Header Column
The best way to manage this is to add a new column, let’s call it “Group Header Column” as a virtual column so that it is updated whenever the SUM is updated. The expression for this column would be like this:
[Column Count] & " - " & [Group Column]
The assigned value would be like this “1234 - Group Column Value”
With the “Group Header Column” established and assigned, you would next adjust the Table View to use the [Group Header Column] as the Group column and set it to Descending order. Then set the Aggregate to “None” since you are aggregating the value in the column itself.
Adjust Table View Grouping
CAUTION: If your table used in the implementation above is large, understand that the two virtual columns can add significant processing time to the Sync.
1 Like
Both Expression Not working Showing Error
Please can I share my app to u and help me out
1 Like
No. I don’t mean to be rude, but if I do that, you won’t learn much. Those of us that post here are App Creators like you and have our own apps to build. If we were to log into others apps to implement things for them when requested, we would not have time for our own work.
We are here to try to help you, not do it for you.
Please try to follow the above conversation and try implementing the solution yourself.
If you get stuck at a certain point, then post those details in a NEW post so you can get others in the community to help as well for FASTEST response.
2 Likes
It was pointed out to me that I missing including the SELECT in the SUM expression. Oops! It should be like this:
SUM(SELECT(Your Table[Value to be summed], [Group Column] = [_THISROW].[Group Column]))
1 Like