I may not totally be following what you are trying to do, but here are a couple things you could do to get you there.
It looks like the only selection the user has is on the prior year and the current year is fixed. You could try the following...
Create the following calculated field "PriorYearMax":
[DatePaid] <= dateadd('year', -1, Max([DatePaid]))
Add this to filters and set to TRUE. Your viz will now only include data from the max date minus a year.
Depending on the specifics of the rest of your requirements, you could use a parameter to control the start date on both sheets, or default it to the first of the year or perhaps change the existing filter to only allow the user to change the starting date not the ending date.
I hope that helps!
1 of 1 people found this helpful
Try wrapping DatePaid in ATTR()
ATTR([DatePaid]) <= dateadd('year', -1, Max([DatePaid]))