|
CROMM is a macro for making pivot tables.
In them quatities of interest are shown in the same table using two dimensions (columns and rows).
The sums are presented in cells, i.e. overlapping areas of columns and on rows.
Making a pivot-table using CROMM requires that the dimensions (fields) to be used in tabulation
and the amount(s) related to them are within the records planned to be used [1].
|
|
|
CROMM can be regarded as an additional analysis tool for IDEA, in particular for IDEA's
older versions.
CROMM complements IDEA.
Various versions of the macro also provide you with an alternative way e.g. to make
payments receivable age analysis.
Best benefit from CROMM is gained with the help of IDEA's statements and functions.
E.g. record extraction and appending virtual character fields extend the possibilities to
make pivot tables using CROMM.
|
|
|
When using CROMM, fields used as tabulation dimensions must be of character type.
The numeric value can only be in a numeric field.
In IDEA many functions are available for creating virtual character fields from other field
types (e.g. @str(text,lenght,decimals) and @dtoc(date,mask)) - and vice versa (e.g. @val(amount)).
You can use IDEA functions also to clean special characters - such as '/','&', '%' -
from character fields in order to make them valid as column fields of CROMM table (TABLE.IMD).
Examples of these functions are '@strip(text)' and '@replace(text, string_to_be_replaced,
replacing_string') [2].
|
|
|
You could have made pivot tables e.g. in Excel, but not very large ones.
Using CROMM you can make tables even exceeding the 1000 * 1000 cell limit in IDEA 2002.
|
|
[1]
To be able to tabulate sales of various districts by product groups (two dimensions) records
in tabulation must contain sales information, district information and product group
information.
Other information, e.g. sales day, seller and campaign (three more possible dimensions) give
several additional possibilities in cross-tabulation (theoretically, in the example, seven
more ones).
[2]
Representation of functions here does not comply with that used in IDEA.
E.g. in IDEA @strip(text) is 'sexpr sexpr @str(sexpr)',
where 's' in 'sexpr' tells the type of the field (s = string; n = numeric;
d = date).
|
|
|