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 toolbar, click
Add new visualization,
, and select
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 $433 value represents the sum of toys purchases made by men in New York during February.