Restrict using Factor Levels

Select menu: Spread | Restrict/Filter | To Groups (Factor Level)

Use factor levels or labels to restrict the rows displayed and to be included within an analysis.

Restrictions can be applied to Matrices and Tables, although these structures cannot be restricted within the Genstat server. If the Subset on update option is selected, then a reduced matrix with restricted rows removed will be sent to the server. Otherwise the restrictions within the spreadsheet will be used for display purposes only and the full data will always be used within the server.

From the menu select Spread | Restrict/Filter | To Groups (Factor Level).

Factor

The factor by which the spreadsheet is restricted. A dropdown list of factors in the spreadsheet is available for selection.

Selected levels

The levels that are to be included or excluded from the available rows. A single level can be selected by clicking on it with the mouse. Multiple levels can be selected by holding down the Ctrl key while selecting. Holding the Shift key down while selecting levels selects all levels between the selected item and the last selected item.

Restriction type

Units (rows) matching the selection criteria can be either included or excluded from the data displayed in the spreadsheet and used in subsequent calculations.

Existing restrictions

If this spreadsheet is currently restricted, this controls how the new restriction is added to the current restriction.

Combine with new	Combine the old restriction with the new one.
Replace with new	Replace the old restriction with the new one.

Action buttons

OK	Restrict the spreadsheet as required, and close the dialog.
Apply	Restrict the spreadsheet as required and leave the dialog open to apply further restrictions.
Remove all	Remove any existing restriction from the spreadsheet.
Cancel	Close the dialog without making any further restrictions.