Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to perform YTD and PYTD without selecting any date
you could try something like the following
=sum( {$<Date = {">=$(=floor(yearstart(Max(Date)))<=$(=Max(Date)) "} >} Value)
=sum( {$<Date = {">=$(=floor(yearstart(addmonth(Max(Date),-12)))<=$(=addmonth(Max(Date),-12)) "} >} Value)
i mean wat happend