How to Add Columns to a Data Sheet Matrix

1. Navigate to the Edit Columns tab.
   
   
   
2. Click 'Add…' on the right-hand side.
   
   
   
3. Use the Select Content dialogue box to choose which columns to include.
   • You can select multiple columns to add.
     
     

1. Click 'OK'.
2. Adjust each column’s settings by clicking on the blue text when the column is selected.

Adding columns to the data sheet matrix is demonstrated in the short clip below:

How to Add a Sub-Column to a Data Sheet Matrix

Sub-columns allow additional information related to a column (rather than the Query elements) to be added to the Matrix. They are located beneath their main column with an indent to allow clear visibility.

1. Navigate to the Edit Columns tab.
2. Click 'Add sub-column…' on the right-hand side of the column block you want to add the sub-column to.
3. Select the sub-column from the Select Content dialogue box.
   • You can select multiple sub-columns at once.
4. Click 'OK'.
5. Adjust the sub-column settings by clicking on the blue text when the sub-column is selected.

Adding sub-columns to the data sheet matrix is demonstrated in the short clip below: