Cross table
A cross table is a two-way table consisting of columns and rows. It is also known as a pivot table or a multi-dimensional table.
It is a grid of cells defined by a Row axis and a Column axis. In some places they are called Vertical axis and Horizontal axis). On these axes, data columns are specified to organize the data. The actual contents of the table cells are aggregated values, for example, sums or averages of the data, defined by the intersection of the two axes. What data you want to aggregate is selected in another axis, the Cell values axis.
Its greatest strength is its ability to structure, summarize and display large amounts of data. You can also use the cross table to determine whether there is a relation between the row variable and the column variable.

- Row axis (or Vertical axis)
- Column axis (or Horizontal axis)
- Cell values
You can change the appearance of the cross table. For example, headers can be displayed horizontally or vertically, and the horizontal as well as the vertical alignment of the header texts can be specified.
Example
Below is a cross table showing the sum of sales for different types of fruits and vegetables.

The same data displayed in a regular table takes up far more space and it is much more difficult to get an overview:

You can display grand totals for columns and rows (the example above shows grand totals for columns as well as rows). See Displaying totals to learn more about totals.
- Creating a cross table
Cross tables are used to summarize large amounts of data, and then present the result in a structured table format. - Displaying totals
You can display grand totals for columns as well as rows in a cross table. If the vertical axis is hierarchically structured, it is possible to display also column subtotals for different levels in the hierarchy. - Changing height and width in tables
You can change row height and column width in tables and cross tables to better suit your content. - Sorting values in a cross table
You can sort the aggregated values in the cross table columns as well as in the cross table rows. - Styling in the cross table
You can change the appearance of the cross table in many different ways. - Formatting in the cross table
It is possible to format the values in the cross table on any of the axes. You can format the values either by opening the Formatting section of the visualization properties, or, in the installed client, by right-clicking directly in the cross table. The example below illustrates how formatting can be applied to a cross table in the installed client. - Marking values in cross tables
When you want to further explore the data summarized in the cross table cells, it is possible to mark all cell values in a column or in a row simultaneously. - Images in the cross table
Cross tables can be configured to show images in axis labels.