Hi,
I want help in scripting logic, we have sales data date wise and outlet wise for each employee ID, we want to consider latest OutletID if count(OutletID)>1 in a month. Ex- If an employee has been moved from one store to another in between the month, entire month sales should reflect against the new outletID. This check should be applicable only for month data, not for hist data.
Please suggest me the solution.
I think if we use count(OutletID) and do group by EmployeeID,month,year. we can see the change in outlet and then condition if (Count OutletID)>1, take the max(date) and corresponding Employee Id. But m not able to script it.
Any help is appreciated.
Regards,
Navdeep
