AnsweredAssumed Answered

Getting subtotals in a portal

Question asked by StefanÖstlind on May 9, 2012
Latest reply on May 11, 2012 by philmodjunk


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.