4 Replies Latest reply: Mar 28, 2015 2:03 PM by PAUL YEO RSS

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

    PAUL YEO

      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.

       

       

      Paul