I built the formulas shown below and I am trying to change the "2016" to "last year" and the "2017" to "this year" so it will not need to be updated each year. The reason I am using formulas for this is that I want to show each year as its own column in the report but I also have other formulas that show first sale date and last sale date, etc so I can't just pull in the sales by year and pivot...too much other info in the report. Is there a way to replace 2016 with 'last year'...i currently get an error...
if(year ( date / time )=2016)then sales else 0
if(year ( date / time )=2017)then sales else 0