Calculate the linest

[#1]

I Need to calculate the linest (Slope) for each given location so i can know if the trend is up or down.

In EXcel i used the formula  = linest( range) which be bigger or less than zero

I attached the excel sheet. Please help me

[Gysbert_Wassenaar]

Linest_m won't work with categorical values. So your x-axis values need the be numeric too. This can be done by for example creating Quarter as a dual field. See attached qvw.

[#3]

It gives exactly the values i need but when i apply it to my file it gave different values. See the data

first i wrote a script to get the table values as i gave it to u

And in the table view values look like this

and i apply the pivot table to make sure values match which gave me this

which match the table values i gave you and then i did the slope and the values i got different. I feel its something to do with percentage.

[#4]

Hello,

Attached is my solution. Please let me know if this is what you meant to do.

/LC