My data source is only updated once a month (at the end of the fiscal month) to show the value for that fiscal month. I want to show this value in my Summary Number, but when I use current values, it shows 0, because there is no data for the current month (as it has not yet closed). My Date range needs to be year-to-date because I am showing a trend over time. Any suggestions?
