7 Replies Latest reply: Feb 24, 2018 7:41 PM by Anil Samineni RSS

    My SET expression now display YTD sales , How to modify so that it will display last 3 year instead of YTD ?

    Yeo Poh sai

      Hi Sir



      My expression work fine :-


      Sum(Aggr(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000), GROUP_CLASS))


      I don't know how to modify the above expression to compute last 3 year sales. Hope some one can advise me.