1 Reply Latest reply: Sep 10, 2012 4:00 AM by whiteline _ RSS

    Get Max Date selling rate Using set analysis

    Muniyandi Vasimalai

      Hi.

       

      How to get Max Date selling rate Using set analysis.partwise ,itemwise.

       

      I select Year or Month

       

      Not Working:

       

      My Expression:

       

      ONLY({<YEAR=,Month=,SalesDate={"=((Aggr(NoDistinct Max(SalesDate),PARTYID,Item)))"}>} Rate)

       

      My sample file attached.Pls hlep.

       

      Regards,

      Muni