1 of 1 people found this helpful
Try adding a calculated field along the lines of:
DATEDIFF('year',[Order Date],Today())<[Choose period]
and add this to the filter shelf setting to true. Last part on the year quick filter set the option to Only relevant values. This should get you close.
At the moment you are using LAST() which is a table calculation and performed after the dimensional filters; essentially you are getting all years back in the results and then 'hiding' some of those years which is why the totals don't always work.
an excellent solution - which seems to be working fine also with my original (and a bit more complex) view.