Balance between 3,6 and 12 month Dates

[Rhino84]

consider the given table:

ACC	OPEN_DT	BAL	3m_new_bal	6m_new_bal	12_new_bal
10	12-Jan-20	10
11	14-Mar-20	23
12	16-Jun-21	10
13	9-May-15	21
14	7-Oct-19	10
15	20-Apr-18	67
16	23-Dec-96	10
17	12-Jan-83	54

I want to construct a new table that has 3 new columns (Blank columns shows above) which holds the sum of BAL between the range open_date and 3 months after open date, 6 months after open date and 12 months after open date

[PaigeMiller]

Do you want to do this by account (ACC)? Or across all accounts? I am not understanding this part. Could you explain in more detail.

Also, for this simple example, it would help if you could fill in the cells of the desired output table.

Finally, please go back to your original post and change the subject line to something meaningful that describes the problem. Every question here could have a subject line of "Need Help", but that's not acceptable really.

[Rhino84]

YES. I want this for all accounts (each individual account)

[PaigeMiller]

---

@Rhino84 wrote:

YES. I want this for all accounts (each individual account)

---

Okay, but then don't we need more data for each individual account? Please show us data that corresponds to this explanation.