Aggr(NODISTINCT) Function Help

[riceball]

Hi,

I've encountered one problem when trying to use aggr() function. As shown in the attached, my expression for current product name doesn't seems to work.

Only (IF(Date(aggr(NODISTINCT MAX(Date),Channel,Country))=Date(Date),Name))

Instead of having "-", i would like my result to look like this (please see highlighted cells).This column will reflect my latest product name based on the latest date, group by channel (A/B):

Please advise. Appreciate your help on this

[Gysbert_Wassenaar · Accepted solution]

You can use these expressions:

date(max(total <Channel,Country> Date),'DD/MM/YYYY')

FirstSortedValue(total <Country,Channel> Name, -Date)

See attached qvw

[riceball]

It works! Thank you so much for your help!!!!