I have to create a chart based on weekly average of Calculation1 in attached report based on bank and weeks are defined by last 7 days from the run date e.g if report is run for 01/23/2017 then week will include from 23rd to 17th, 16th to 10th

Daily Data:

day                bank      Calculation1

01/23/17       Bank1       100

01/23/17       Bank2       200

01/20/17       Bank1       300

01/20/17       Bank2       700

.

.

.

Expected Results: (if run for 01/23/17)

Bank            Week1 Average(23rd to17th)          Week2 Average (16th to 10th)...................

Bank1          400                                                       300

Bank2          500                                                        450   

.

.

.

.