Drag to crosstab one or many elements

Updated at October 3rd, 2022

Create crosstabs in Protobi by dragging the label of one element onto another:

Crosstab elements individually

Drag + drop

Drag one element (q1) to the heading of another (q2) to create a crosstab. The element you drag will define the columns (or "banner"), and the other will define the rows (or "stub"). 

Press on the + sign on any element to choose from a list of crosstab banners. The crosstab banners in the drop-down are based on the element you add to your "banners" tab.

Drag elements from the tree to crosstab

You can also drag from the element tree on the left. This is useful when crosstabbing variables that are not on the same tab.

Crosstab elements globally

Drag onto the the "Crosstab"  button in the toolbar to define a global banner.  Any elements and charts that can take a banner variable will be crosstabbed.

To remove, click on the crosstab button, and select "none"

Crosstab with two banner variables

Elements can take up to two crosstab banners. Once an element is crosstabbed by one banner, a second "+" button appears, and you can drop another banner. 

The columns are sorted by the first level banner, and then the second. 

If you double click on either banner, it will switch the order:

Global crosstab with two banner variables

You can apply two crosstab banners globally. Drag the first banner to the crosstab button, then start dragging the second banner over. Before you drop the second banner, hold down the shift key.

This should allow the crosstab button to take both banners:

When you create a global crosstab with two banner variables, an option to "swap" will appear. Below, the project is crosstabbed by specialty (S1) first, then practice start (S3). Press swap to crosstab by S3 first, then specialty.  

Crosstab significance tests

Admins can change crosstab significance tests in Project properties. The default mode is Complement testing.


In Complement testing, each column is compared with the average of all other columns (excluding itself). Blue cells indicate the value is significantly higher in the specified column compared to all other columns, and grey indicates significantly lower. 


Pairwise testing compares each column with each other individual column. This mode shows detailed superscripts like a traditional crosstab. 

Below we see that the percentage of respondents who rated their health as "Excellent" is much higher in column A (Very happy) than columns B, C or D. 

Note: Protobi limits significance testing to N>=20 to avoid testing when the sample size is too small. 

Video Tutorial


Create crosstabs by dragging on variable to another. Cell shading highlights significant differences. To uncross, we can drag S1 out of Q2. 

Crosstab every variable in the survey by dragging it to the crosstab button in the toolbar. Select clear to uncross. 

Was this article helpful?