Last modified by: Inclusion Support -

Crosstab

 Crosstabs.png

  • Crosstab can also be called a Pivot Table.

  • Use the Crosstab function to summarize your data based on your chosen headers and labels.

  • The Crosstab function also allows you to automatically sort your data by sum, count, average or standard deviation.

  • The required fields when creating a crosstab are as follows:

    • Header Values Column: Select your desired header value from the drop down. The crosstab will create one columnfor each unique value.

    • Label Values Column: Select your desired label value from the drop down. The crosstab will create one row for each unique value.

    • Aggregate Values Column: Select your desired aggregate value from the drop down. This will be the data content of the crosstab.

    • Aggregate Function: Select the function to be used from the drop down.

    • Click Add.

  • Note that the values in the header and label drop down menus are the column headers from the original table.

  • Multiple Crosstabs can be added to the report and will appear below the orginal table.

Print Friendly and PDF

Head back to the Inclusion Support Home Page.

Contact the Includables!

1 (866) 884-3451
includables@inclusionsystem.ca