| Returns the data cell matrix.
A crosstab can have multiple data cells for row/groups totals.
These cells are organized in a (rowGroupCount + 1) x (columnGroupCount + 1)
matrix as following:
- the row index of a cell is
- the row group index, if the cell corresponds to a total row
- rowGroupCount, otherwise
- the column index of a cell is
- the column group index, if the cell corresponds to a total column
- columnGroupCount, otherwise
E.g. if the crosstab has Country and City (subgroup of Country) row groups and Year and Month column
groups, the cells will be organized in the following matrix
|
0/Years total |
1/Months total |
2/Base |
0/Countries total |
Total for all countries and all years |
Total for all countries and a year |
Total for all countries and a month |
1/Cities total |
Total for a country and all years |
Total for a country and a year |
Total for a country and a month |
2/Base |
Total for a city and all years |
Total for a city and a year |
Total for a city and a month |
If the data cell for a total row/column is not specified, the cell will be inherited
from lower levels, if possible. For example, if the "Total for all countries and a year"
cell is not specified, the "Total for a country and a year" or "Total for a city and a year"
cell will be used (in this order).
The data cell sizes are calculated from the base data cell sizes, i.e.
the height of all data cells for a row will be the height of the base cell
of that row. The base cell sizes are also inherited, e.g. if the height of a total
row is not specified the height of the base row will be used.
the data cell matrix |