TIBCO Cloud™ Spotfire® Web Client User Guide

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.

  1. Row axis (or Vertical axis)
  2. Column axis (or Horizontal axis)
  3. 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.