Getting subtotals in a portal
I need to make a table where I get the subtotal of delivered units in a portal in my bookings layout. Let me explain.
I make one booking to deliver units to a client of different sizes.
I then source these units from 2 suppliers.
I have one table for bookings and one for supplied units where the supplied units is a table of supplier code and no of units. I join each delivery of units to a booking reference in the bookings table.
In the bookings layout I then want to look at a booking and see how many units each supplier has contributed with in total. I only manage a running total for each supplier or a total for all suppliers.
Very grateful for any help here.