Creating a cross table

Cross tables are used to summarize large amounts of data, and then present the result in a structured table format.

The cross table is a grid of cells defined by a Vertical axis and a Horizontal axis. On these axes, data columns are specified to organize the data.


Cross table example with labels

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.

Procedure

  1. On the authoring bar, click Visualization types to open the flyout.
  2. Drag the Cross table visualization type to the wanted position on the analysis page.
    A suggestion of a cross table is presented.
  3. On the Vertical axis, select one or more columns containing the categories that you want to use for organizing the rows in the cross table.
  4. On the Horizontal axis, select one or more columns containing the categories that you want to use for organizing the columns in the cross table.
  5. On the Cell values axis, select the column whose values you want to aggregate.
  6. Select which type of aggregated value you want to use.

Example

The data table contains purchases made by customers in January, February and March at two different store locations.


sample data table

The cross table below gives you an overview of the monthly sum of toys purchases made by men and women at each store location.


cross table example

For example, the value $433 represents the sum of toys purchases made by men in New York during February.