In the Variable-window there is a ‘Categories’ button. This button is active when a Categorical variable is marked.
Mark an original categorical variable (red icon) and we can add a new category to it by clicking the ‘Categories’ button.
Mark a derived categorical variable ‘Categories’ button and this window pops up:
Select ‘New Category’ and give the new category a name.
All categories in the derived variables are defined by a formula. We can now add a formula to category. The Formula Editor
Mark a derived categorical variable containing more than 2 categories it is possible to merge categories. For example, if we mark this variable:
- And press the ‘Category’-button, then we can select ‘Merge Categories’
- A new window pops up and we could select a merge of for example ‘Strongly Agree’ and ‘Agree’
- As soon as the two categories are merged the categories in this variable will change into this:
- As seen in the related formula the new merged category is defined by ‘OR’
When a derived categorical variable contains more than 2 categories a NET can be created. A NET is a category, which adds two or more categories from the variable into an extra category – a NET.
This feature can be used for producing Top boxes and Bottom boxes:
- And press the ‘Category’-button, then we can select ‘Create NET’
- A new window pops up and we could select a NET based on for example ‘Strongly Agree’ and ‘Agree’ as we see above.
- As soon as the two categories are selected a new NET- category is added to the variable:
- It is optional to add more than one NET to a derived categorical variable.
When OfficeReports produces tables containing NETs we will automatically format the categories contained in the NET:
Font size 2 smaller than other categories (not less than size 6)