3 Replies Latest reply: Sep 18, 2015 1:21 AM by Yeo Poh sai RSS

    How to partial laod a field to display last 1 month sales ?

    Yeo Poh sai

      Hi All



      I need to get a field for check last 1 monthj company sales amount .



      so i create a partial load script below :-



      left join    (sales)


      Load desc,



      sum(if(Month_n<2,sales)) as L6MS



      Resident sales group by desc;



      Result I wanted  :-



      Table 1 return correct value 314,474



      Table 2 return wrong value. how to make table 2 display 314,474 ?



      The reason i make use of Month_n is so that i can replace Month_n<2 to 6 , finally i want to get their last 6 month sales amount.