In this article
You may wish to create certain table layouts that are not possible through the use of variables in columns and rows alone. For example, you may want to have the distributions on your grid questions displayed horizontally, but the items vertically.
To create tables such as this there are two “helper” objects, Categories and Statistics, available show me.
Figure 1 - Setting up the table using Categories and Statistics objects
Categories provide the questions’ answer list. In Statistics, you can apply one or more of the statistics described in Statistics if the question(s) are numeric, ordered or have weights defined.
To be able to cross a variable with the Categories and Statistics objects, you must set the Collapsed property on the variable (go to Collapsed for more information). Both the Statistics and the Categories objects can be nested with other header variables.
You can also use Categories and Statistics to create a condensed table with several questions that have the same answer list. You could, for example, drag in several other questions into the table above, as long as all the questions use the same point scale.
Note: You can cross a Formula object with a Statistics object, but you cannot cross Statistics with Statistics; if you attempt to do this an error message will be displayed.
Show Title
To apply a header to your categories, select the Show Title checkbox to activate the functionality and define titles for each of the report’s languages .
Figure 2 - Defining titles for the various languages in Show Title
Texts
On the statistics object, you can override the system default texts for the various statistical elements and define your own texts . You can also do this for the entire report in Report Properties > Layout and Styles tab >Custom Texts.
Figure 3 - Texts on the Statistics object