I want to export the data of a forecast view into Excel. How do I do that?
Step-by-step guide
- Each view is assigned to one or more forecast file. Open the forecasting console to find out.
- Make sure you identify the file that is associated to the active view you are interested in.
- Open Power Tools
- Choose: 'Conversion>>Forecast Views to Excel'
- Find your forecast view file in this list:
- As you type the file name, it'll auto-complete. Once you find it, hit: 'Open'
- aaaand that doesn't work. I don't know, man. It didn't find the PWF file. It only finds the xls file, and this file is empty.