Summing of multiple filtered portals
Hi, I've got 3 tables - commissions, products and services. In the commissions layout, there are two portals - one for product sales and one for services rendered which are retrieved from other relationships in the database. As I require filtering of the portals, I made a summary of the product totals and service totals within each portal. Thus, I was able to sum the individual filtered portal but faced difficulty in summing the resulting sums of the two filtered portals to generate a final amount. Any suggestions?