In your orders table, you need a field that uses the Sum() function to total your line_items.
Create a new calculation with:
Sum ( Line_Items::Amount)
Now you can display that field on a list of orders with their sum of line_items. And you can summarize that calculated field for a grand total of all the orders in your found set list.
Thank you!- that worked.