Summary Number to show last month's value


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?

Best Answer

  • Johnf
    Johnf Contributor
    Answer ✓

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


This discussion has been closed.