Filtering summary amounts
I'm working with a database containing tables for customers, orders, payments and invoices. Orders include both delivered (hence payment is due) and pending (no payment due yet). In FP11 I can filter the portal data on the invoice layout so only delivered orders are shown. But I can't figure out how to filter the summary total so only delivered orders are added up, to calculate a total due (minus payments). Any suggestions?