This content has been marked as final. Show 3 replies
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)
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.