1 of 1 people found this helpful
Did you try filtering out using a table calculation instead of using Year directly on the filter? The formula and table calc settings are shown in the screenshot below.
Table calc filters hide the marks. So LOOKUP will be able to look at previous year (2013) even though the Date Filter shown in the screenshot only keeps year 2014 since the filter applies after the LOOKUP function works and just hides the bars.