2 Replies Latest reply: Aug 4, 2014 1:36 AM by PAUL YEO RSS

    when i select mth=2 yr=2014 it How to make it sum from 2013 jan till 2014 Feb ?

    PAUL YEO

      Set command how to make it can sum sales from date i click ?

       

       

      Hi All

       

       

      I have the SET expression , which is half okay :-

       

       

      sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}[TOTAL_AMT]/1000)

       

       

      Can some one help to modify the expression , so that it can sum from date i selected.

       

       

      Now when i select year=2014 & month = Feb , it will sum from :-

      2014 jan till Feb

      2013 Jan till Feb

       

       

      what i need is it will sum :-

      2014 jan till Feb

      2013 Jan till Dec

       

       

      Paul