You can use a Quick calculation for this, specifically the 'Running Total' calculation.
See attached, which required the following:
1. Dragging in another Sum(Sales) calculation
2. Applying a Running Total quick calculation
3. Dragging Account to columns (or you could set up as a filter instead)
The Both Calculations sheet required setting up with Measure Names and Measure Values so as to see in two columns.
Start up another thread to advise on that topic, or check out this link: Measure Names and Measure Values
Hope this helps.
20181013 Balance_v10.4.twbx 90.7 KB