Please see if the attached could be a first step for you.
Instead of filtering, this uses a parameter for the selection of the year.
This way, all the data remains and can be used for the previous year lookup.
What is needed is a way to just show the year that you want.
This requires a calculation like this:
Then when that is put on the Rows shelf, just hide the Null year.
For this to work, you will have to "Edit table calculation" for PreviousYearSales
with a "Compute using" of Advanced and selecting the correct Addressing.
207630Arrow Chart Example.twbx 331.5 KB