Predicting Future Years


Is there a way to predict future year sales (5 years in the future) based on past performance and have it output in the form of a table instead of a bar graph or line graph? I can figure out how to find the 3-YR historical performance or 5-YR historical formance but how do I use such a formula to look forward 3 to 5 years into the future?


This is a pretty open ended question, because how are you predicting forward? You can easily jump around time frames using simple time intelligence questions but the reality is you need to have a good idea of how you’re going to predict some forward before you do that…

Here’s some ideas