Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution:
This was just the practice I needed! Please, make more Time Series challenges!
Here is my submission.
I created two macros, one for reading the information in and the other to be a batch macro to read in the product type information for the time series forecasting. I finished with a crosstab to resort the forecast values by their period sub-period and product for 2017.