I'm not sure this really helps or not, anyways.
This is display filter with table calculations.
Not filtering data, but only display.
Report FY2018_SM_10.1.twbx 48.2 KB
Thank you! This works great!
I'm having trouble understanding the logic behind your lookup field. Could you spell that out for me?
I have another issue regarding this. So now I can use your lookup calculation along with the Lookup Filter to do year-over-year calculations.
But I can't use that filter on a dashboard if I want to filter other data for different years. Basically I need a global filter on a dashboard where I can filter the data as well as link my calculations to that filter (Which was possible with your last solution, but doesn't work with filtering any other data)