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 to open the Visualization types 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 Row axis (sometimes called 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 Column axis (sometimes called Horizontal axis), select one or more columns containing the categories that you want to use for organizing the columns in the cross table.

Note: When you select more than one column on the Row axis or Column axis, you are setting up a hierarchy, which is a very powerful feature in a 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.

Note: You can also set up your cross table by dragging a column of interest from the Data in analysis flyout and dropping it on one of the three drop targets shown.

The data table contains purchases made by customers 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 $1537 represents the sum of toys purchases made by men in New York during February.