Grouping Data from One Sheet to Another Sheet

[AshishSoni]

please suggest how can I group items from List sheet, grouping by  customer name, factory code of each order id separately and count number of pieces final or pending grouping customer code & factory name of each unique orders. This I have done by query in google sheet but not in Appsheet.

Order SheetList Items of Ref Order Sheet

[Simon_Robinson]

Create a table view of that data.  Then in the table settings could choose your group by columns