Creating a cross table

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

Before you begin

See Cross table for a description of the concept.

On the authoring bar, click Visualization types to open the flyout.
Drag the Cross table visualization type to the wanted position on the analysis page.
A suggestion of a cross table is presented.
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.
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.
On the Cell values axis, select the column whose values you want to aggregate.
Select which type of aggregated value you want to use.

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

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

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