5.6 Use of the "Cross-table"
(Shift-F5, Shift-F6,Shift-F4)
The powerful flexible tool of the UNIDAT program is also function of
creation of the cross table. With its help it is possible automatically to
create the tables of resulting data, in which as in rows, and the columns can
be repeating real databases given from any two fields.
On crossings of lines and columns of these tables amount of
records with concurrence of those and other data or sum of meanings
of any numerical field at such records will be counted.
The amount of the various tables with all possible
combinations of such orders is very great, many of them, certainly, will not
caus of practical interest in daily activity of the experts on a
specific database (and some even will not have of any reasonable
sense), but it shows, that including for huge amount of practical
needs of the consumers of the given information the powerful mechanism of the
given function by skilful use can appear the very useful operative tool and in
a numbers of cases and irreplaceable.
To use opportunities of this function it is necessary to carry out
following:
1. To establish the cursor on a field, on
data from which lines of the table will be constructed and to press a
combination of keys Shift-F5 ("Vertical list").
2. To establish the cursor on a field, list of data from which will be
generated columns of the table and to press a combination of keys Shift-F6
("Horizontal list").
And all is completed!
At once after it will be
automatically generated and is deduced on the screen formated
for print the necessary table - report, filled counted on the given
combination of fields by data.
If it is required that the table was filled not by amount
of records, satisfying given conditions, and the total meaning on
any numerical field from these records - requires before start on
execution of function of creation of the table (before to press
Shift-F6), to carry out a choice of a field, on which data will be
summarized.
This field should without fail be numerical. For a choice of a field, on which
data will be summarized, it is necessary to put on this field the cursor and to
press a combination of keys Shift-F4 ("Choixe a field for
summation"). The same keys can be and for switching mode of summation off.
The modes of a conclusion of the table are set the same as and at a
simple print, described in item " Print of the simple lists ".