In this article
In addition to all of the properties you can apply to the table itself, there are also properties that you can apply to the header variables. The properties available for the variables will depend on the type of the variable.
To open the property sheet for a header variable, double-click on the header variable or right-click on it and select Properties .
Figure 1 - Opening header variable properties
You can select multiple header variables to edit their properties simultaneously. To do this, press and hold the Ctrl key on your keyboard while you select the required headers, then click the Properties button in the toolbar, or while continuing to hold the Ctrl key, right-click on the headers and select Properties. Note that only "common" properties that apply to all the selected headers will be available in the resulting properties sheet.
You can duplicate a header variable. To do this, right-click on the variable and select Duplicate. Note that if header variables are nested, you can duplicate the lowest variable (right-click on the appropriate lowest level item) or the entire nested set (right-click on the top item).
Default Settings
As part of the aggregated table style (go to Aggregated Table Styles for more information), you can specify default header variable settings for all the different types of questions and variables that you can use in the aggregated tables. This means that you can save time when defining your tables, because the settings you normally apply have already been specified globally. You can override the settings locally for a particular variable by unchecking "Use Default Settings" .
Figure 2 - Use default settings
Filters
The Filters property in the Header Variables property sheet allows you to apply filters only to intersections containing this header variable. This can remove the need to create and nest a segment containing the filter condition.
Show Title
Check the Show Title box if you want the titles to be included in the table .
Figure 3 - "Show title" selected for Favorite and Gender
The titles of variables in rows can either be displayed beside the answer list, as in this example, or as separate rows above the answer list, depending on the “row nesting” table property setting (go to Row Nesting for more information). When several variables are nested, titles will only be shown on the outer level.
Titles have an upper limit of 30 characters. If a title contains more than 30 characters, it will be truncated and ended with an ellipsis (…), but the full text will be available as a tool tip.
Decimals
You can override the table decimal setting by specifying the number of decimals to use in the results for a specific header variable. Type a positive integer into the field.
Note: You can increase the number of decimal places displayed to reduce the effects of rounding and thereby increase the accuracy of the displayed data.
Sorting and Top/Bottom N
You may sort the values in your tables based on the responses. Sorting must be based on the values from the intersection with one of the other variables in the table. This other variable either must have only one item, or a total that the sorting can be based on.
You can sorting ascending (1,2,3…) or descending (10,9,8,7…) by selecting “Direction.”
You may also define Top and Bottom N. This will show only the specified number of elements in the table. For example, if you type 5 in Top N, only the top 5 elements will be displayed. The other elements will be removed from the table.