0 Replies Latest reply: Mar 24, 2016 6:54 AM by Yeo Poh sai RSS

    How to convert Month_n to SET ?

    Yeo Poh sai

      Hi All



      I have below expression from Table 2 which is using Month_n and need to select current month and year :-




      sum({$<Month_n={$(=max(Month_n)-0)}, month=, year=>} $(ColumnDim51)/$(Columndim89)/1000)




      I like to change the above expression by using SET with don't need to select on current month and year. and it will return current month sales.