I'm trying to create a forecast trend line, based on the avg sales of previous months. so, starting next month i would like the line to begin at the avg amount, and every month after that i would like to incrementally add the average to develop a trend line over time. i.e. a loop would be ideal but not sure how this works in qlikview. does anyone have any ideas?