Grouping in Browsebox?

I have some specific request from my client. So I have simple orders browse (usual SQL table, standard BrowseBox) with several columns including “route” and “customer” columns.

And the request is that orders which have the same route and customer should be grouped together in one row + have some total columns.
However, the user can have the functionality to expand such line in order to see in detail all the orders in a group.

What is the best and easiest way to implement this?


The easiest way is to use SQL view instead of SQL table as data source for browse box, for that view you write sql code to group such rows.

probably I can try this way. thank you for idea

Most likely, my approach would be to define an SQL view using appropriate aggregate functions.
If browse rows can be updated, there will be additional considerations for which you will need to code.