I have a dynamic table with data for my delivery co. I have a drop down to select different weeks via indirect function. Among the things that I keep track of are total gross revenue, total orders, revenue/mile, revenue/hour, orders/hour, etc.
I’d like to add a feature to this table that shows which of these are trending up or down. Ex- last week my revenue per mile was $1.17 and this week it’s on track for $1.32, that would be up.
Can you explain how to use the forecast function?