Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to display the max date for a given set of values filtered by an indicator:
What I have so far:
= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-price)
however, that is giving me the max date for all the values:
I tried this:
= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-Max({<indicator={'QQ'}>}price))
but I get the error " error in expression: nested aggregation not allowed"
What can I do to fix it? I know I need to use AGGR() but I am getting a null value .
= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-aggr(Max({<indicator={'QQ'}>}price),[Dates.autoCalendar.YearMonth]))
= FirstSortedValue(DISTINCT [Dates.autoCalendar.YearMonth],-aggr(Max({<indicator={'QQ'}>}price),[Dates.autoCalendar.YearMonth]))