I have a basic Orders table with a related Line_Items table.
The line items table contains a summary field (total_qty) which totals all the qtys on the individual lines for a particular order. This total_qty field works fine to show me the total quantity for each particular order.
I also have an Orders Summary Layout which displays a list of all the orders, including the customer name, order date and total quantity on each order.
I'm trying to get the footer to show the total units for the found set of orders but can’t get this to work properly.
Not looking to create a report, with sub summary parts. I just want the Sum of the total_quantity field to show up at the bottom of the layout.
Please advise. Thanks!