Summary Number to show last month's value

brianallen

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?

Johnf

Use a beast mode calculation to sum last months data and then click the apply to summary number box.

Johnf

Use a beast mode calculation to sum last months data and then click the apply to summary number box.

brianallen

Thanks, John!

Johnf

@brianallen, Glad I could help