You can add new items to a table field or axis, such as totals, sub-totals, percentages, rates, and differences. These are known as derivations.
Derivations can also include mathematical and statistical functions, such as the mean and standard deviation.
There are two types of derivation in SuperCROSS:
- Field derivation - this type of derivation can use field items from a specific field in a table as variables. Field derivations are used directly in a field and become part of that field.
- Axis derivation - this is similar to a field derivation, but can use any of the items in the axis as part of the derivation (in a field derivation you can only select values from a single field).