I could not find any solution on any other discussion.
Could anyone please help me on this?
I basically want linest_m function to use only a limited time period to project the trendline.
The red-dotted line gives the forecast using linest_m and linest_b function
=LINEST_M(TOTAL aggr(sum(OrderQty),YearMonth),YearMonth)* YearMonth
+ linest_b(total aggr(sum(OrderQty),YearMonth),YearMonth)
Is there any way I can ask the linest_m and linest_b function to use the values from 201204 to 201303 to use as history and project the trendline?