For a countings table (parentid, item, qty) (one scan=one record), is there any way to create virtual table or a list of its summary/aggregrated results for creating UX?

[Oran_M]

So that parent UX can show its related summary children UX (parentid, item, sum(qty)) which may contain few items/records instead of related children UX which may have 100 records counted of few items or products.

or how to add table from pivot-table sheet (database style, no ‘total’) ?