Understanding measures

A measure in a crosstab is a value that appears in an individual cell. By default, a measure value is a count of the values that match the cross of the fields in the rows and columns.

To create a new measure, drag a field and drop it in the main area of Table. Select an operator for this field, for example sum, mean, minimum, or maximum. To render the crosstab, calculate the cells using the chosen dimensions and operator.

Use Advanced—Measures to change or add measures used in the analysis. In contrast to Table, Advanced supports adding complex measures that interact with other measures, changing or adding axes, and changing the order of the measures.

1 In Advanced, on Measures, select a measure, as shown in Figure 4‑3. Double‑click a measure to open it for editing.

2 Select an operation. For example, select sum, average, maximum, minimum, or count.

3 Select the field or table to which to apply the operation. The count operation requires that you select a table, not a field.

4 Select filters for each measure, if necessary.

5 Select a display format for the results. For example, select total, % column, % row, or % total.

6 Select a display type for the result. For example, select values, index, or difference.

To reuse a measure, drag the measure from one analysis window and drop it in another.

After defining simple or standard measures, you can define calculated measures. For example, to estimate cost per operation, define a calculated measure that divides the sum of operation costs by the number of operations.

1 Create simple or standard measures. For example, create Cost Sum and Cost Count.

3 In Alias, type a name for the calculated measure. For example, type:

4 Right-click and choose the simple measures and operators from the context menu.

5 Choose the check mark to confirm that the syntax is correct.

How to create a new measure based on an existing measure

3 Replace fields, or edit filters, formulas, values or properties of the duplicate measure.