Creating a category based on other categories
You can add a category that contains the results of a calculation based on the values in other categories. You can do this by adding a derived category to the variable. To create formula for the category, you can add or subtract the values in the other categories, or use a function from the UNICOM Intelligence Data Model.
For example, in this table the age variable has a derived category called "55 or over", created by adding together the values in the 55-64 years and 65+ years categories.
Table showing category "55 or over" calculated from two other categories
To create a derived category
1 In the Variables pane, select the variable, and then click Variables > Edit Variable.
The Edit Variable window opens.
2 Click Categories > Insert Categories.
The Insert Categories dialog opens.
3 In the list of Available Items, select Derived category and click the >> button to add it to the Items to insert list.
4 In the description field, replace the default description with the text that you want to appear on the table, for example, 55 or over.
6 Drag the 55-64 years category to the box on the right of the screen.
7 Type a + symbol (optionally, include a space before and after the symbol to make it easier to read).
8 Drag the 65+ years category onto the right of the screen after the + symbol. The expression should now look like this:
E5564_years + E65_years
9 Click OK to close the Edit Derived Category dialog, and then click OK again to close the Insert Categories dialog.
10 Choose Save and Close to close the Edit Variable dialog.
See also
