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

    Aggr(NODISTINCT) Function Help

    Shihui Zhang

      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):

       

      Sample.png

       

      Please advise. Appreciate your help on this