why do you need to replace the dynamic value with hardcoded value? if you want to replace than you should replace something like
Max(year)-1 with 2016
Max(year)-2 with 2015
Max(year)-3 with 2014
but this would make no sense as next year max(year) will be 2018 for and it will show you the unintended data .