Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am using a master calender with my entire dataset, but want to show just the max(MonthYear) for just one particulare data set
I have tried a variation using set analysis, but have not quite got the code right yet, could someone kindly help me with the correct code
{<data_source={'18_Wks_Admitted'}>}Max(MonthYear),'MMM YYYY')
Kind Regards
Helen
Hello
Problem solved
=
Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)
Hello
Problem solved
=
Max({<data_source={'18_Weeks_Admitted'}>}MonthYear)
Like this
=Sum({<MonthYear={$(=Max(MonthYear))}>}Sales)
Hope it helps you..!