This content has been marked as final. Show 2 replies
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