Doubt on how to create a custom dimension for a project

[esmartins1983]

Hi Community,

I'm in need of assistance with the following situation (please refer to the attached screenshot).

For each company name listed in column A, there are two bank accounts listed in column B. Every month, we receive information about the balance of each account in column D and the respective income in column E. All columns are already included as report dimensions in Google Looker, with the exception of column F.

I'm attempting to create a custom dimension using Looker expressions that calculates the cumulative sum of income up to the month listed in column F for each bank account associated with each company. 

Does anyone have any clue how this can be done?

[sam8]

That's tricky. I know you can create subtotals in table visualizations, and you can create running total table calculations. But putting them together to make running totals that reset after each subtotal? I'm not sure it's possible.