Matrix structure

The "Advanced Matrix" object consists of the following elements:

Corner

The cells located in the corner of the matrix can contain arbitrary information. You can also split/combine them as you like.

Header

Matrix header can contain two types of elements:

• simple element: displays static information such as the text "Total".
• group: displays a list of values grouped by a specific criterion.

The header has a tree structure. The root element is invisible, it contains visible first-level elements.

Any arrangement of elements is allowed; for example, a header may not have a group, or it may have several adjacent groups. The totals can also be arranged in an arbitrary way.

In design mode, the matrix displays visual cues in the header area:

In this case, the header structure is as follows:

Row header
- "Name" group
- "Total" element

Column header
- "Year" group
  - "Month" group
- "Total" element

See section Header Setup for more information.

Data area

Cells in a data area usually contain an aggregate function. See section Data Area Setup.