Show time distributions in a report
For some field data and field title cells, for example, units and costs, you can report time-distributed data. You can also specify how you want to see summary data reported across the timescale; for example, you can select to display data for each timescale interval, or period totals only.
- In the Report Editor window, click the text cell whose time distributions you want to show, then click .
- Click the Cell tab. In the Timescale Type field, select the type of data you want to report.
- Mark the Repeat Over Timescale checkbox, then click .
- In the Data Source Header area for the data source that contains the cell, select the row in which you want column labels for the time distributions to appear, then click .
- Click the Cell tab. In the Cell Type field, select Variable.
- In the Cell Variable field, select Column Date.
- Mark the Repeat over Timescale checkbox.
Tip
- The values distribute according to the date interval, or timeperiod, you specify for the report. To change the date interval, click the Report tab, then click Timescale Options.
Specify a timeperiod for a report