Change Trend Options

Change trend options to specify the number of time units that are forecast forward for a trend value or trend percentage column.

When using forecasting, you can select the time period that you want to use. For example, if the trended column groups data by week, trending forward three units shows data trended three weeks in the future.

Tip: You can also edit trend options from the Trend Options group on the Design tab after selecting the column on the design surface.

1. Right-click the trend value column on the design surface and select Edit Trend Options.
2. Select the Perform Forecast check box to enable forecasting.
3. Enter the number of units.
4. Click OK.