Locations, State, Time Periods, and Sales Columns
Column Group Heading | Single Column Heading | Name on the Layouts Detail Page | Column Name on the Layouts Detail Page | Column Type on the Layouts Detail Page | Editable by Default | Source |
---|---|---|---|---|---|---|
Locations | This column is displayed only if you specified the Worksheet to display data for a single time period and multiple locations. The location for which generated data is displayed for the specified time period. | |||||
State | This column is displayed only if you specified the Worksheet to display data for a single time period and multiple locations. The state of each location displayed on the Worksheet, as described above. For information on states, see States. | |||||
Time Periods | This column is displayed only if you specified the Worksheet to display data for a single location and multiple time periods. The time period for which generated data is displayed for the specified location. | |||||
Sales | Last Year Actual Sales | SALES | FCIT_SALES | Column | no | The sales according to last year's actual data. |
Sales |
This Year Actual Sales |
SALES | FCIT_SALES | Column | no | The sales according to this year's actual data. |
Sales |
Budget Sales |
SALES | FCIT_SALES | Column | no | The sales in the reference budget. |
Sales |
System Forecast Sales |
SALES | FCIT_SALES | Column | no | The sales according to the generated forecast. |
Sales |
Adjusted Forecast Sales |
SALES | FCIT_SALES | Column | yes | User-edited sales for the forecast. |
Sales |
Sales % Change From Budget |
SALES | SALES_ PERCENT_ CHANGE | Calculated | no | The ratio of the number in the user-editable Adjusted Forecast Sales column, to the number in the Budget Sales column, expressed as a percentage. |