Just so I'm clear are you talking about getting a running total for every month?
The running totals should be calculated by how your columns are organized. Try moving the account pill in front of the dates. The running total calculation should change from there.
Let me know if this works for you.
Also, if you attached the workbook you are working on, helping you would be a little easier.