Table generated at trip level

In the following table, the cell contents show not only the counts, but also the sum and mean summary statistics of the DaysAway numeric variable. This is a trip-level variable that stores the length of the trip in days. The sum values show the total number of days away and because the results are generated at the trip level, the mean values show the mean number of days per trip.

Summary statistics of a numeric variable in the cell contents - generated at Trip level

To create this table

1 Expand the Trip grid within the Person loop, and add the purpose variable to the side.

2 Add the gender variable from the Person loop to the top.

3 Open the Table Properties tab (F4) and in the Cell Contents tab, add Sum to the list of items to include in cells.

4 Select Sum, and in the Based on field at the bottom of the tab, select person[..].trip[..].daysaway.

5 Add Mean to the list of items to include in cells, and base it on person[..].trip[..].daysaway as in the previous step.

6 Click OK to apply the settings to the table, and generate the results.

Look at the three figures in the top left cell of the table. The first figure is 24, which corresponds with the base in Table 4: Trip-level variables tabulated at the trip level, which tabulates two trip-level variables at the trip level. This figure shows the total number of overseas trips that were taken. The next figure is 320, which is the total number of days for all the trips. The final figure is the mean, which shows the average number of days per trip.

See also