I have a card that shows This years Sales by month v Budget - works fine.
I want to show a summary number that is YoY% - formula wise, this is not a problem - except that as the date filter on the card is set for current year...meaning last years sales are not available to use in the YoY formula.
Any ideas?