Hi,
Im trying to get the year to date table presented in month, I need the month name and budget data to be shown in the table.
However, date is not provided for the budget data only the month and the year available, so that budget data could not be linked to the date created from master calendar. I could not figure out the solution to get it solved. The script below doesn't work, any help would be very much appreciated.
=sum({<Month={">=$(=Num(Month(Yearstart(Date))))<=$(=Num(Month(Max(Date)))"}, Year= {'$(=Year(Date))'}>}Budget)