Linest_M, calculating the slope

[#1]

Hi all,

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:

2 Questions:

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!

[#2 · Accepted solution]

sum is obsolete in the Linest_M statement