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.
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
