When you format a data-entry table in design mode, you can set up a pairwise matrix to copy a user-entered value diagonally to ensure the matrix sorts correctly.
You can set up a pairwise matrix to evaluate priority or to measure the strength of a relationship between row and column values. To set up a pairwise matrix, you must first create a data-entry table that has the same variable in both the row and column.
When you make the diagonal cells the same in a pairwise matrix, Engage copies the user-entered value to the corresponding diagonal cell. This is useful for sorting when the copied values in the pairwise matrix are hidden by conditional formatting, as shown in the following image.
- In Design mode, connect the data-entry table to a data table, then choose either of the following filter options.
- Show all rows or Show all columns
- Populate rows based on filter criteria below or Populate columns based on filter criteria below
- Connect the control in the repeating row and the control in the repeating column to the same data field.
- At the intersecting cell of the repeating row and the repeating column, double-click the control, then select Always make cross-diagonal cell values the same. In Fill Out mode, when a user enters a value in the repeating row, the value is copied to the corresponding cross-diagonal cell so the matrix sorts correctly.
