Running Totals
Dear All
I have a requirement regarding running totals in output. Please to attached file DataSample.xlsx
In this sheet I have a column Payment6 whose formula is Payment1 - Payment4 for Order 1. For second record for same order, formula for Payment6 would Payment6 - Payment4. But for the third record order number changes to 2 and this time I again want to calculate using formula Payment1 - Payment4. Is there a way to achieve this requirement?