4 Replies Latest reply: Feb 5, 2016 12:34 AM by jagan mohan rao appala RSS

    How to make my table YTD sales = Jan + Feb Amount ?

    PAUL YEO

      How to make my table YTD sales = Jan + Feb Amount ?

       

       

      Hi All

       

       

      I have below expression from Mr Manish  :-

       

       

      SUM({<year = {"$(=Max(year)-1)"},rEVENUE={"rEVENUE"}>}Amount*1)/1000

       

       

      it work fine , but now i like to modify it , so that it can give me YTD sales .

       

       

      Meaning if i click on month = 2 , i like it display jan + feb amount.

       

       

      Can some one help me ?

       

      I will post my QV sample in few minute.

       

      PAUL