Twelve orders below carry a Quantity and an Amount column, and a grand total row pinned beneath them averages the one and sums the other. Type a region or customer into the filter box: the grid narrows to matching orders and the total updates to describe only what is now in view. Read the full how-to on latticegrid.dev.