Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we change the value of YTD and QTD on the basis of Month Selection.
my current expression is below.
YTD
=sum({$<[Year] = {$(=only([Year]))},[FiscalMonthName]={'<=$(vMaxMonth)'}, [Week] = {'<=$(=max([Week]))'},[Week]=>} [Net Bookings])
Regards,
KK
Maybe. It depends on what value vMaxMonth has and how that variable gets its value.