Thanks in advance for your help!
I have several applications that show a YTD KPI and a line chart with current and previous years by month. I only load the last full month of data, so when January rolls around, I would like for the apps to show the total previous YTD through December and the prior year. When February rolls around, I'd like to see January YTD and the previous year.
I'm using autocalendar, so when the year changes (I use yearsago), it automatically shows January and therefore shows no data for the previous year, which I want to show Jan-December.
This seems like something that a lot of people would run into, but I haven't found much on the message boards. Your help is greatly appreciated.