When you format a data-entry table in design mode, you can set up a pairwise matrix to
copy a data 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, Workspace copies the data 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.
