7 Replies Latest reply: Sep 21, 2015 3:52 AM by Yeo Poh sai RSS

    Possible to compute last 5 month sales with out using partial load  ?

    Yeo Poh sai

      Hi All



      I want to compute last 5 month sales.



      Now i have YTD script which give Year To Date sales :-





        If(Num([date]) >= $(vYearStart) and Num([date]) < $(vMonthNow), -1, 0) As YTD,



      May i know how to modify the above script , so that it will return last 5 month sales amount.





      Hope some one can advise me ?