Compiling Forecast, Real and Trend Data [Mix columns]: Once having calculated the day-of-the week or week's trend, you can use the Mix Columns operator to specify the time up to which trend data is required in the restatement of old data, and when the original forecast data is used.