Yes. In V7 you can do it with a bit of work. Joe did a demo of this at the end of a TDT he gave a couple of weeks ago (it's toward the end of the session). In V8 forecasting will be much easier, as there is now a "forecast" option.
I know this thread is old but it would be really useful to be able to see this demo.
Does anyone have any information on this or possibly even a sample workbook?
Thank you for the help.