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 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.
- On the authoring bar, click Visualization types to open the flyout.
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.