Chart with Dates

[evansabres]

I have a field nwEVENTDTE, which is formatted as mm/dd/yyyy. I have another field called [Net Sold Qty]

What I want to do is to create a table that shows the field nwEVENTDTE less certain time intervals and the [Net Sold Qty] at those times.

So, for example

nwEVENTDTE-7 (or 14,21,28,etc for week intervals) and the [Net Sold Qty] at that time. Ideally, I want a chart that displays the following as an output.

Time Frame               Net Sold Qty

1 Week                    ##,###

2 Weeks                    ##,###

3 Weeks                    ##,###

4 Weeks                    ##,###

6 Weeks                    ##,###

8 Weeks                    ##,###

10 Weeks                    ##,###

12 Weeks                    ##,###

Any suggestions on how to structure this would be appreciated.

[evansabres]

Ideally, I would like to have a chart (straight table) where once you select an event date (nwEVENTDTE) the table would display the number of tickets sold ([Net Sold Qty]) at each of the time intervals. So, if I pick the nwEVENTDTE of 12/12/2016, I would want a chart (table) displaying the number of tickets sold ([Net Sold Qty]) at different time intervals.

Event Date          Tickets Sold 1 Week before Event Date          Tickets Sold 2 Weeks before Event Date

12/12/2016                    ##,###                                                       ##,###