Managing Columns & Rows

The column and row dialog boxes allow you to add variables from the questionnaire to the Data Spreadsheet.  Any variable in the questionnaire can be added to a column or row including custom variables and custom derived variables. Variables can be added to the column or row dialog boxes individually or as folders. 

Selecting Data

You can add variables to the column or row dialog boxes by locating the desired variable in the questionnaire using the search bar or scrolling through the variables. After locating the variable or folder you wish to use, click and drag it into the column or row dialog box desired. You can add multiple variables and folders to the column and row dialog boxes for ease of access.

Applying Data

Once you have added the individual variables and/or folders to be used as columns and rows, click the Calculate button in the upper right hand corner of the Crosstab Builder page to populate the variables into the Data Spreadsheet. Crosstabs in the Data Spreadsheet will be automatically generated. If you are using multiple filters, the variables and crosstabs will be applied across all filter tabs in the Data Spreadsheet.

Removing Data

You can remove variables and folders from the column and row dialog boxes by selecting the variable, right clicking on the variable, and then clicking remove. You can also deactivate variables by unchecking the red box next to the variable. After you have made any changes in the column or row dialog boxes, click the Calculate button in the upper right hand corner of the Crosstab Builder page to apply the changes to the Data Spreadsheet.



Other articles in this section: