Currently I have the following measure in place which performs a standard budget allocation over the number of days in the month for each day. I am trying to show the running grand total in the pivot grand total cell, however, I am continuing to get a blank although I want to show the final date value (the running total) as part of grand total cell.
My current measure is:
SR YTD Targets =
VAR LastNonBlankValue = CALCULATE ( MAX ( DIM_Dates[Date] ) )