Populate a segment reporting line item table

The following steps describe how to populate a segment reporting item in the Segment Reporting Worksheet.

Prerequisites

You must have the information you need to perform this analysis.

Procedure

1. Use the drop-down at the top left of the segment item table to select the map number and description. The Total Allocation field is automatically updated with the map number balance.

   

2. Alternatively, manually type the description and total into the input fields provided.

   

3. Manually type values into the rest of the table. The Primary segment columns and Secondary segment lines are all input cells. The Total column keeps a running total of the values that you have typed.

   

Results

The item in the Segment Reporting Worksheet is complete.