1. Home
  2. Knowledge Base
  3. Ad Hoc Views
  4. Example – Migration Summary Crosstab
  1. Home
  2. Knowledge Base
  3. Examples
  4. Example – Migration Summary Crosstab
  1. Home
  2. Knowledge Base
  3. Videos
  4. Example – Migration Summary Crosstab

Example – Migration Summary Crosstab

The following video shows an example of a Migration Summary Crosstab Ad Hoc View.


The Crosstab includes the following information:

  • Gender
  • Residency Status
  • Migration Visa Category
  • Count of Clients

This is a Crosstab view that allows you to quickly view the total number of Clients who have a particular visa and residency status.

The final crosstab is grouped by Residency status and Migration Visa Category so you can quickly view all the International students on Humanitarian Visas.

Residency Status and Visa by Gender


If you need to see all female Permanent residents with a Family visa, you could move the Migration Visa category to Columns and Gender to Rows. The results would be grouped by Gender, then Residency split into Visa columns (see below)

Gender and residency status by Visa

While the data itself remains the same, changing the display location or order splits the figures in different ways.


The Crosstab is useful for counts of measure across a combination of groups, but if you want a more graphic representation, you may find a Chart Ad Hoc View is more useful.

Further Information

For information on creating Crosstab Ad Hoc Views, refer to the following article:

Updated on April 19, 2018

Related Articles