I need to calculate the slope of the trend per product/Department for 5 months in my script.
This wil be used later on in a dashboard to indicate if formentioned combination has a positive or negative trend.
The script I've thusfar is:
1. is it necessary to generate all combinations of Product/department/Dates with Amnt = 0 when they do not exist
2. Will the coding be appropriate in order to calculate the correct slope for the combinations...
thx in advance!