2 Replies Latest reply: Apr 14, 2013 9:26 PM by Shi Hui Zhang RSS

    Aggr(NODISTINCT) Function Help

    Shi Hui Zhang



      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