Has anyone been able to implement linest_m function in a pivot table with set analysis? I am looking for a couple of pointers.
I have a Fact table which has many different facts concat'd together. I want to find the slope on only 1 type of fact say, Sales Dollars/Sales Units for the last 6 months.
I was trying to do the trend line in a pivot but that's not possible so the slope is the next best thing to it.