I have several columns but the first column has dates, the second is the number of units sold up to that date. These dates are from last year. I would like to find the number of units sold up to the date one year ago.
The closest that I have got is:
this gives me the total number units sold last year, not to date minus a year.