Choose "Year" in Page Level Filter - display Year and Prior Year
I have a brain bender (at least it has been for me). I have a card I want to display "Sales vs Prior" - if the user chooses a "Year" (2015, 2016 or 2017) in the page analyzer I want this card to display the year they picked, and the year prior to that choice as well.
Any ideas on how to approach? I have attached sample data as well.
This is what I would want the user to see if they picked "2017" as the year (2016 and 2017).
This is what I would want the user to see if they picked "2016" as the year (2015 and 2016).