I have for dynamic form with repeating fields. There are three subtotals one for each sales person (that do not repeat). I would like to add the sum for each sales person from the "Sales" field depending on which sales person is selected in the "SalesPerson" drop down field. Please note that these are not in tables, but just Text, Drop Down and Numeric fields lined up like a table.
Example:
TotalSales
Jill 35
Bobby 20
Mike 30
Total 85
Sales Person Sales
Jill 10
Mike 20
Jill 10
Jill 15
Bobby 20
Mike 10