I have a table like such & the line for the Forecast. I'm wanting to add a month row as well. How would i incorporate the Month and Day into the forecast?
linest_m({<Day=>} total aggr(if(sum({<Day=>}PTPAmount),sum({<Day=>}PTPAmount)),Day),Day)*Day
+linest_b({<Day=>} total aggr(if(sum({<Day=>}PTPAmount),sum({<Day=>}PTPAmount)),Day),Day)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
