Use the Spreadsheet Options dialog box in the Activity Usage Spreadsheet and Resource Usage Spreadsheet to display the timescale based on an average value you specify.
Calculate Average: Mark to specify the values you want to use to divide the timescale interval totals.
Divide Interval Totals By: To divide the timescale interval totals by an increment you specify, type it in this field.
Base on Hours Per Timeperiod: To divide the timescale interval totals by automatic increments, based on the date interval selected, mark this checkbox. When you choose this option, the Divide Interval Totals By field displays the division increment based on the division increment specified in User Preferences for the corresponding date interval: 1h for Hour date interval, 2h for Shift date interval, 8h for Day date interval, 40h for week date interval, and so on.
Unit of Measure: Specify the unit of measure for the timescale intervals.