Working with crosstabs in stories

Crosstabs are used in stories to display all the original data from a dataset. By default, a crosstab is sized to fit into its container, but you can use Expand Crosstab to See All Rows to show all of the data on a single page. This setting changes the page to continuous scrolling mode.

When you select Expand Crosstab to See All Rows, the page's horizontal dimensions remain the same, and if the width of the crosstab is greater than the width of the page, you can use the scroll bars to view all columns.

This feature is available for Infographic pages.

Using pictograms and shapes with crosstabs

You can place pictograms and shapes on your visualization. You can place these items on a crosstab if Expand Crosstab to See All Rows is not selected. If Expand Crosstab to See All Rows is selected, these items cannot be placed on the crosstab.

Limits to the amount of data available in a crosstab

The amount of data you can retrieve from a data source is customized by your administrator. This may result in the crosstab displaying fewer rows than are available in original data source.

Exporting to PDF

Stories that contain crosstabs can be exported to PDF. If Expand Crosstab to See All Rows is selected, only the first 100 rows are exported.