Hi Everyone,
I have a Datasets what needs to be drilled down to day and employee level. I have the data on shop level. i have list of employees with an employee number and number of hours they work. i need to drill it down based on the hours they work. and i need to have the data on day level.
employee has a shop_cd but i need to have the target on dealer_ID because i need to concatenate it later on a table useing Dealer_ID
In short Target column from month to day and Target column from shop level Divide by the total workers of a shop based on worked hours.
