3 Replies Latest reply: Sep 18, 2015 1:21 AM by PAUL YEO RSS

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

    PAUL YEO

      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.

       

       

       

       

      Paul