Hi,
Is there a way to pull out of the Forecast the # of months and if it’s predicted to increase, decrease, or remain consistent to use in a BAN at the top of the dashboard?
In the attached workbook, there’s a forecast and a BAN. The forecast for the last three months is consistent which is what I’d like to show in the BAN (red text).
Workbook is attached.
Thank you!
1 个回答
I'm guessing this can't be done because we can't get to the underlying forecast calculations -- or at least that is my thought after looking more at it but will take any and all ideas or suggestions.
Thank you
