How can I sort and sum data in different record?

[Jeff_Hager]

I think this may be what you want.

Multiple "Group by"

What exact “bugs” were you facing? You can sort of do a “unique” setup in Glide. Create a rowID column for the first table. Create a relation from the Store column to itself, make it a multiple match. Create a single value column on top of the relation above, returning the rowID from the first match. Create a rollup column on top of the relation to count the number of orders. Show the inline list of the first table, filter by rowID is the same as the “first match” rowID in step 3. Display t…