4 Replies Latest reply: Mar 28, 2015 2:03 PM by Yeo Poh sai RSS

    set expression can display YTD sales , but can allow me click on month = feb

    Yeo Poh sai

      Hi All



      I have currenct yr set expression below :-



      sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} REVENUE/1000)



      This expression give me YTD sales for 2015 = 1592 is correct.



      But when i click on Feb month , it display only feb sales = 526 , which is not what i want.



      when i press on feb , i need it display sum of jan and feb revenue 2015 = 1592.



      when i click on jan , i need it display sum of jan revenue 2015 = 1065.



      Hope some one can herlp me.