I have a table with records of customers invoice amounts.
I want a field that shows in each row of table view the balance of all invoices for each customer. When I add a record with new invoice this balance field will be changed
Name Invoice No Amount Balance
Customer A Invoice 1 100 250
Customer A Invoice 2 150 250
Customer B Invoice 3 300 450
Customer B Invoice 4 100 450
Customer B Invoice 5 50 450
I tried with summary field with no luck so far...